Pandas Profiling Report

Dataset statistics

Number of variables	65
Number of observations	1121
Missing cells	20789
Missing cells (%)	28.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.9 MiB
Average record size in memory	3.6 KiB

Variable types

CAT	50
NUM	10
BOOL	3
UNSUPPORTED	1
URL	1

Reproduction

Analysis started	2022-11-01 01:42:00.760781
Analysis finished	2022-11-01 01:42:27.841817
Duration	27.08 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`type_of_disaster` has constant value "Hurricane"	Constant
`_project` has constant value "CMMI-1761461"	Constant
`fulcrum_id` has a high cardinality: 1121 distinct values	High cardinality
`general_notes` has a high cardinality: 127 distinct values	High cardinality
`photos` has a high cardinality: 1120 distinct values	High cardinality
`building_address_sub_thoroughfare` has a high cardinality: 835 distinct values	High cardinality
`building_address_thoroughfare` has a high cardinality: 357 distinct values	High cardinality
`building_address_locality` has a high cardinality: 52 distinct values	High cardinality
`building_address_full` has a high cardinality: 1101 distinct values	High cardinality
`other_details` has a high cardinality: 99 distinct values	High cardinality
`other_structural_details` has a high cardinality: 73 distinct values	High cardinality
`damage_description` has a high cardinality: 344 distinct values	High cardinality
`qc_notes` has a high cardinality: 919 distinct values	High cardinality
`effective_year_built` is highly correlated with `year_built`	High correlation
`year_built` is highly correlated with `effective_year_built`	High correlation
`general_notes` has 992 (88.5%) missing values	Missing
`photos_caption` has 35 (3.1%) missing values	Missing
`building_address_suite` has 1066 (95.1%) missing values	Missing
`building_address_country` has 29 (2.6%) missing values	Missing
`assessment_type` has 40 (3.6%) missing values	Missing
`assessment_type_other` has 1081 (96.4%) missing values	Missing
`year_built` has 81 (7.2%) missing values	Missing
`effective_year_built` has 145 (12.9%) missing values	Missing
`number_of_stories` has 57 (5.1%) missing values	Missing
`roof_shape` has 53 (4.7%) missing values	Missing
`roof_shape_other` has 1111 (99.1%) missing values	Missing
`roof_cover` has 136 (12.1%) missing values	Missing
`roof_cover_other` has 1046 (93.3%) missing values	Missing
`wall_cladding` has 90 (8.0%) missing values	Missing
`wall_cladding_other` has 1081 (96.4%) missing values	Missing
`other_details` has 1017 (90.7%) missing values	Missing
`structural_framing_system` has 89 (7.9%) missing values	Missing
`structural_framing_system_other` has 1099 (98.0%) missing values	Missing
`roof_sheathing_nail_spacing` has 1110 (99.0%) missing values	Missing
`roof_sheathing_nail_size_other` has 1120 (99.9%) missing values	Missing
`roof_to_wall_connection` has 631 (56.3%) missing values	Missing
`roof_to_wall_connection_other` has 1121 (100.0%) missing values	Missing
`opening_protection` has 285 (25.4%) missing values	Missing
`opening_protection_other` has 1056 (94.2%) missing values	Missing
`garage_door` has 95 (8.5%) missing values	Missing
`garage_door_location` has 1002 (89.4%) missing values	Missing
`garage_door_failure` has 770 (68.7%) missing values	Missing
`other_structural_details` has 1040 (92.8%) missing values	Missing
`damage_modes` has 149 (13.3%) missing values	Missing
`damage_modes_other` has 1113 (99.3%) missing values	Missing
`number_of_sides_used` has 86 (7.7%) missing values	Missing
`damage_visible_in_photos` has 79 (7.0%) missing values	Missing
`damage_description` has 678 (60.5%) missing values	Missing
`water_height_inches` has 1064 (94.9%) missing values	Missing
`structure_usable` has 54 (4.8%) missing values	Missing
`qc_notes` has 48 (4.3%) missing values	Missing
`year_built` is highly skewed (γ1 = -28.25839657)	Skewed
`effective_year_built` is highly skewed (γ1 = -27.79443758)	Skewed
`fulcrum_id` is uniformly distributed	Uniform
`general_notes` is uniformly distributed	Uniform
`photos` is uniformly distributed	Uniform
`building_address_suite` is uniformly distributed	Uniform
`building_address_full` is uniformly distributed	Uniform
`other_details` is uniformly distributed	Uniform
`other_structural_details` is uniformly distributed	Uniform
`fulcrum_id` has unique values	Unique
`roof_to_wall_connection_other` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`overall_building_condition` has 196 (17.5%) zeros	Zeros
`first_floor_elevation_ft` has 513 (45.8%) zeros	Zeros

fulcrum_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct count	1121
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

32c1b935-d086-4d5d-8f23-2bd154ee20ec	1
570bf794-4f46-42d7-a1f6-b837542e6893	1
638497a4-5e6a-4642-96a1-79ad383994dd	1
94be4887-e026-4108-a067-87b3ff52326f	1
2fe82398-d5c1-4e3e-bc22-60eba2d6015c	1
Other values (1116)	1116

Value	Count	Frequency (%)
32c1b935-d086-4d5d-8f23-2bd154ee20ec	1	0.1%
570bf794-4f46-42d7-a1f6-b837542e6893	1	0.1%
638497a4-5e6a-4642-96a1-79ad383994dd	1	0.1%
94be4887-e026-4108-a067-87b3ff52326f	1	0.1%
2fe82398-d5c1-4e3e-bc22-60eba2d6015c	1	0.1%
87ca20ec-5860-4c11-9c5c-49ddb809c9b7	1	0.1%
f5a928e2-506a-4f90-ba94-03e08795f606	1	0.1%
05e1da84-5463-4df4-a497-6c9867b1bdc8	1	0.1%
f695043a-61a4-45c1-a7ba-028ba0cc9281	1	0.1%
efde4816-653e-4891-a9e6-b888c45e98a2	1	0.1%
Other values (1111)	1111	99.1%

Length

Max length	36
Mean length	36
Min length	36

Value	Count	Frequency (%)
Decimal_Number	10	58.8%
Lowercase_Letter	6	35.3%
Dash_Punctuation	1	5.9%

Value	Count	Frequency (%)
Common	11	64.7%
Latin	6	35.3%

Value	Count	Frequency (%)
ASCII	17	100.0%

latitude
Real number (ℝ_≥0)

Distinct count	1092
Unique (%)	97.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25.507950154799286
Minimum	24.553088
Maximum	30.01545947
Zeros	0
Zeros (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	24.553088
5-th percentile	24.62562831
Q1	24.672029
median	25.809741
Q3	25.953294
95-th percentile	26.17857
Maximum	30.01545947
Range	5.46237147
Interquartile range (IQR)	1.281265

Descriptive statistics

Standard deviation	1.117350394
Coefficient of variation (CV)	0.04380400569
Kurtosis	7.144334435
Mean	25.50795015
Median Absolute Deviation (MAD)	1.02111
Skewness	2.380072911
Sum	28594.41212
Variance	1.248471902

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
24.654928	4	0.4%
24.65532	3	0.3%
24.656112	3	0.3%
24.660932	2	0.2%
24.677913	2	0.2%
24.660915	2	0.2%
24.726729	2	0.2%
24.727006	2	0.2%
25.949719	2	0.2%
24.655325	2	0.2%
Other values (1082)	1097	97.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
24.553088	1	0.1%
24.566691	1	0.1%
24.567435	1	0.1%
24.568201	1	0.1%
24.568206	1	0.1%

Value	Count	Frequency (%)
30.01545947	1	0.1%
30.01505	1	0.1%
30.014873	1	0.1%
30.014699	1	0.1%
30.014469	1	0.1%

longitude
Real number (ℝ)

Distinct count	1093
Unique (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-81.44529188086528
Minimum	-81.87274471
Maximum	-80.0335956
Zeros	0
Zeros (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	-81.87274471
5-th percentile	-81.729641
Q1	-81.71397
median	-81.40977
Q3	-81.363024
95-th percentile	-80.88812929
Maximum	-80.0335956
Range	1.83914911
Interquartile range (IQR)	0.350946

Descriptive statistics

Standard deviation	0.295710113
Coefficient of variation (CV)	-0.003630782162
Kurtosis	4.283420978
Mean	-81.44529188
Median Absolute Deviation (MAD)	0.191448
Skewness	1.756083456
Sum	-91300.1722
Variance	0.0874444709

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-81.385195	3	0.3%
-81.728888	3	0.3%
-81.385217	3	0.3%
-81.601202	2	0.2%
-81.71625	2	0.2%
-81.385847	2	0.2%
-81.699249	2	0.2%
-81.716051	2	0.2%
-81.388146	2	0.2%
-81.730084	2	0.2%
Other values (1083)	1098	97.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-81.87274471	1	0.1%
-81.810663	1	0.1%
-81.805015	1	0.1%
-81.80484186	1	0.1%
-81.79862	1	0.1%

Value	Count	Frequency (%)
-80.0335956	1	0.1%
-80.12752	1	0.1%
-80.131579	1	0.1%
-80.132527	1	0.1%
-80.18625	1	0.1%

name_of_surveyor
Categorical

Distinct count	26
Unique (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

Sarah Stevenson	133
Shiling Pei	103
Maryam Refan	79
Zheyu He	76
Glenn Overcash	72
Other values (21)	658

Value	Count	Frequency (%)
Sarah Stevenson	133	11.9%
Shiling Pei	103	9.2%
Maryam Refan	79	7.0%
Zheyu He	76	6.8%
Glenn Overcash	72	6.4%
Fred Haan	70	6.2%
Mohammad Moravej	66	5.9%
Jason M. Lopez	58	5.2%
Daniel Smith	57	5.1%
Jean-Paul Pinelli	49	4.4%
Other values (16)	358	31.9%

Length

Max length	24
Mean length	13.1293488
Min length	8

Value	Count	Frequency (%)
Lowercase_Letter	24	49.0%
Uppercase_Letter	22	44.9%
Space_Separator	1	2.0%
Other_Punctuation	1	2.0%
Dash_Punctuation	1	2.0%

Value	Count	Frequency (%)
Latin	46	93.9%
Common	3	6.1%

Value	Count	Frequency (%)
ASCII	49	100.0%

date_of_survey
Categorical

Distinct count	20
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

9/16/2017	240
9/23/2017	184
9/17/2017	183
9/24/2017	146
9/19/2017	98
Other values (15)	270

Value	Count	Frequency (%)
9/16/2017	240	21.4%
9/23/2017	184	16.4%
9/17/2017	183	16.3%
9/24/2017	146	13.0%
9/19/2017	98	8.7%
9/12/2017	63	5.6%
9/20/2017	49	4.4%
9/13/2017	36	3.2%
12/11/2017	19	1.7%
9/25/2017	18	1.6%
Other values (10)	85	7.6%

Length

Max length	10
Mean length	9.064228368
Min length	9

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

type_of_disaster
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

Hurricane	1121

Value	Count	Frequency (%)
Hurricane	1121	100.0%

Length

Max length	9
Mean length	9
Min length	9

Value	Count	Frequency (%)
Lowercase_Letter	7	87.5%
Uppercase_Letter	1	12.5%

Value	Count	Frequency (%)
Latin	8	100.0%

Value	Count	Frequency (%)
ASCII	8	100.0%

_project
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

CMMI-1761461	1121

Value	Count	Frequency (%)
CMMI-1761461	1121	100.0%

Length

Max length	12
Mean length	12
Min length	12

Value	Count	Frequency (%)
Decimal_Number	4	50.0%
Uppercase_Letter	3	37.5%
Dash_Punctuation	1	12.5%

Value	Count	Frequency (%)
Common	5	62.5%
Latin	3	37.5%

Value	Count	Frequency (%)
ASCII	8	100.0%

general_notes
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	127
Unique (%)	98.4%
Missing	992
Missing (%)	88.5%
Memory size	8.9 KiB

Enchanting shores coop park - MH	2
Cyclone-induced tornado	2
Roof lost. According to 22973 construction was late 90??s.	1
Temporary structure (gazebo) in front of the house was destroyed, roof of the back porch was destroyed,	1
Island Montessori School where aluminum soffit failure around metal sided mansard roof failed leading to pressurization and water damage.	1
Other values (122)	122

Value	Count	Frequency (%)
Enchanting shores coop park - MH	2	0.2%
Cyclone-induced tornado	2	0.2%
Roof lost. According to 22973 construction was late 90??s.	1	0.1%
Temporary structure (gazebo) in front of the house was destroyed, roof of the back porch was destroyed,	1	0.1%
Island Montessori School where aluminum soffit failure around metal sided mansard roof failed leading to pressurization and water damage.	1	0.1%
Tile roof damage	1	0.1%
Roof damage - site visited by pre-MAT	1	0.1%
Modular elevated waterfront home. Siding and soffit damage but no damage according to homeowner. Shutters performed well. Siding and shingles replaced in 2014	1	0.1%
New unit According to park manager - appears to have performed well despite attached carport.	1	0.1%
Owner didn't allow us in but part of the roof was completly blown away.	1	0.1%
Other values (117)	117	10.4%
(Missing)	992	88.5%

Length

Max length	558
Mean length	11.06155219
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	26	34.7%
Uppercase_Letter	22	29.3%
Decimal_Number	10	13.3%
Other_Punctuation	9	12.0%
Control	2	2.7%
Currency_Symbol	1	1.3%
Math_Symbol	1	1.3%
Open_Punctuation	1	1.3%
Dash_Punctuation	1	1.3%
Close_Punctuation	1	1.3%

Value	Count	Frequency (%)
Latin	48	64.0%
Common	27	36.0%

Value	Count	Frequency (%)
ASCII	74	100.0%

photos
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1120
Unique (%)	100.0%
Missing	1
Missing (%)	0.1%
Memory size	8.9 KiB

5373b0f4-2911-4b32-b53f-907f48c2f1db,e1a55e54-e1aa-44be-994a-17dfeb2aa642,1958d78f-37a8-4eff-91f9-177f58a94537,a43b8513-7c36-490d-af34-18d5f55a0f4f,eb3d4ef9-daf4-4ad1-b428-c7543b4b9dbc,8bb67872-5f06-41c0-a65d-65ffafe637af	1
fba4da79-d18e-46a4-8793-16e7b18d67bf,90bea214-79aa-4d08-9233-a33a822ac8a0	1
02c29b0e-30e2-4238-a21b-440994f0913b,9f6033b9-ec69-49d5-8c7e-9cd06da0e860,12bfd08c-62f8-4800-875f-261699ac2f1c	1
9f44f26d-be77-41a2-8596-0f5878e31f9b,abf64474-92b9-4155-8da7-6a59d34c20cc,e1e71515-da5e-4dea-a32b-01bf80821c7a,3e0fba7d-96b1-4a4e-a7ae-d3b7c014150a,42e370df-3115-45d2-a8b8-c687ff2d8cac,a4b480da-6aa0-4f38-bebe-8354cf906ae0,b6bdcd13-b6f1-4e4b-9351-3068a1b8e985,11ddad52-c058-45c3-a06e-90634c814544,90a3da13-3c2e-4aa4-982b-1904735d1c05,6955dfe6-fa31-4e7d-8938-a2b044afa42a,316895fe-b348-47db-8d2d-46b53a3d8809,ed100e60-d677-4e1a-97f7-a0cf1ff47a2e,00d8a1f6-86ab-4fc4-aecd-e6f533c08411,fa7afb2b-3774-4e1f-b8ca-921ab60bd946,b59aaa32-f942-468a-a224-65667389c2ef,f932d0f7-e870-461c-a56e-ff57bdd64ca8,aa908ed5-416d-409b-9440-e8ad534c87e9,105307b0-df7a-416b-9144-128ef64c072d,3b6c6c08-4e42-427f-a451-c38c05766335,27524f08-1833-4320-86fb-43417b7f605d,e41c003b-e9b8-40a9-b25a-1f26f93f9233,b8f4faa6-6446-42bd-9ab3-eae9e0febb61,32652956-67e2-4961-91c7-2632eb7bc8da,c96a7ba7-5f81-4711-96b6-3c65210b0a32,c006d177-9dd4-4f70-b386-3b11deb88447,e59f8b4c-fdaf-4cee-972e-224d0dfc6282,91c09dcc-a0bb-477f-804b-d59b83493fa5,4c437a2d-a880-4aea-9f6a-b6b887a08092,d4d07985-9816-418c-bad1-7c387405de78,34ee6790-6f95-4697-a1fc-8ad2d1392f67,07af348f-7691-46eb-a60b-fade0451c178	1
2f11eec3-6c42-4285-99c7-3e3708445d3c,902fe10a-fdfb-4df3-92ac-b81d51d1c0eb	1
Other values (1115)	1115

Value	Count	Frequency (%)
5373b0f4-2911-4b32-b53f-907f48c2f1db,e1a55e54-e1aa-44be-994a-17dfeb2aa642,1958d78f-37a8-4eff-91f9-177f58a94537,a43b8513-7c36-490d-af34-18d5f55a0f4f,eb3d4ef9-daf4-4ad1-b428-c7543b4b9dbc,8bb67872-5f06-41c0-a65d-65ffafe637af	1	0.1%
fba4da79-d18e-46a4-8793-16e7b18d67bf,90bea214-79aa-4d08-9233-a33a822ac8a0	1	0.1%
02c29b0e-30e2-4238-a21b-440994f0913b,9f6033b9-ec69-49d5-8c7e-9cd06da0e860,12bfd08c-62f8-4800-875f-261699ac2f1c	1	0.1%
9f44f26d-be77-41a2-8596-0f5878e31f9b,abf64474-92b9-4155-8da7-6a59d34c20cc,e1e71515-da5e-4dea-a32b-01bf80821c7a,3e0fba7d-96b1-4a4e-a7ae-d3b7c014150a,42e370df-3115-45d2-a8b8-c687ff2d8cac,a4b480da-6aa0-4f38-bebe-8354cf906ae0,b6bdcd13-b6f1-4e4b-9351-3068a1b8e985,11ddad52-c058-45c3-a06e-90634c814544,90a3da13-3c2e-4aa4-982b-1904735d1c05,6955dfe6-fa31-4e7d-8938-a2b044afa42a,316895fe-b348-47db-8d2d-46b53a3d8809,ed100e60-d677-4e1a-97f7-a0cf1ff47a2e,00d8a1f6-86ab-4fc4-aecd-e6f533c08411,fa7afb2b-3774-4e1f-b8ca-921ab60bd946,b59aaa32-f942-468a-a224-65667389c2ef,f932d0f7-e870-461c-a56e-ff57bdd64ca8,aa908ed5-416d-409b-9440-e8ad534c87e9,105307b0-df7a-416b-9144-128ef64c072d,3b6c6c08-4e42-427f-a451-c38c05766335,27524f08-1833-4320-86fb-43417b7f605d,e41c003b-e9b8-40a9-b25a-1f26f93f9233,b8f4faa6-6446-42bd-9ab3-eae9e0febb61,32652956-67e2-4961-91c7-2632eb7bc8da,c96a7ba7-5f81-4711-96b6-3c65210b0a32,c006d177-9dd4-4f70-b386-3b11deb88447,e59f8b4c-fdaf-4cee-972e-224d0dfc6282,91c09dcc-a0bb-477f-804b-d59b83493fa5,4c437a2d-a880-4aea-9f6a-b6b887a08092,d4d07985-9816-418c-bad1-7c387405de78,34ee6790-6f95-4697-a1fc-8ad2d1392f67,07af348f-7691-46eb-a60b-fade0451c178	1	0.1%
2f11eec3-6c42-4285-99c7-3e3708445d3c,902fe10a-fdfb-4df3-92ac-b81d51d1c0eb	1	0.1%
ca603e9a-927b-4bce-a87d-508d1b36df75,79d3e6d6-58fa-427d-b799-df0bdba69809,bfd51ce0-c257-4bf7-996d-e1814509d859	1	0.1%
7f443256-2ad8-457e-8614-6ce5d48f42a3,041a5554-5677-481e-aa00-97c8946a0166,87a3a1a8-c5a5-4b33-aaec-34b69d1678ae	1	0.1%
9db28099-4c32-4094-8a72-e7a978cfcd4a,526413b5-7e07-4d5f-a1de-0b70dfcb2f19	1	0.1%
26c3f76a-b8e2-4963-ac73-8c3ad921a7da,fdc346c5-79fc-4d6e-9a1f-1123c0f6d031,2a747c62-73c4-4976-8415-f14af86b2d02	1	0.1%
68207ea8-81b6-415d-9981-a076280a318c,7069e325-3f59-4730-a979-38436e871102,67802aa2-5396-44d3-ac06-33fa5d40686c	1	0.1%
Other values (1110)	1110	99.0%

Length

Max length	2700
Mean length	155.7832293
Min length	3

Value	Count	Frequency (%)
Decimal_Number	10	52.6%
Lowercase_Letter	7	36.8%
Dash_Punctuation	1	5.3%
Other_Punctuation	1	5.3%

Value	Count	Frequency (%)
Common	12	63.2%
Latin	7	36.8%

Value	Count	Frequency (%)
ASCII	19	100.0%

photos_caption
Categorical

MISSING

Distinct count	22
Unique (%)	2.0%
Missing	35
Missing (%)	3.1%
Memory size	8.9 KiB

,,	286
,	267
,,,	193
,,,,	104
,,,,,	75
Other values (17)	161

Value	Count	Frequency (%)
,,	286	25.5%
,	267	23.8%
,,,	193	17.2%
,,,,	104	9.3%
,,,,,	75	6.7%
,,,,,,	50	4.5%
,,,,,,,	32	2.9%
,,,,,,,,	20	1.8%
,,,,,,,,,	15	1.3%
,,,,,,,,,,,	11	1.0%
Other values (12)	33	2.9%
(Missing)	35	3.1%

Length

Max length	72
Mean length	3.40499554
Min length	1

Value	Count	Frequency (%)
Lowercase_Letter	18	69.2%
Uppercase_Letter	5	19.2%
Other_Punctuation	2	7.7%
Space_Separator	1	3.8%

Value	Count	Frequency (%)
Latin	23	88.5%
Common	3	11.5%

Value	Count	Frequency (%)
ASCII	26	100.0%

photos_url
URL

Distinct count	1120
Unique (%)	100.0%
Missing	1
Missing (%)	0.1%
Memory size	8.9 KiB

https://web.fulcrumapp.com/photos/view?photos=4e04fc8e-8a18-48dd-9cbf-415f0e8e1dd7%2Cf6c190ef-0155-40b2-9645-30fc00894875%2C8158585b-a62f-4768-b02b-6bff1ee42e94%2C2aee37b3-5922-419c-be04-f13b6dbdb9ab	1
https://web.fulcrumapp.com/photos/view?photos=0270d4f5-1629-494d-8256-1b90b89f70e6%2C801addd2-e30f-4c43-a591-0488a8e5f142	1
https://web.fulcrumapp.com/photos/view?photos=1b5acd91-9efc-4e6f-bb38-26528a7539e6%2C83d08691-8a1a-4a67-9d67-0344268219ad%2C7634572f-46d1-4718-8e74-b7ff49f8e803%2Cdc246c20-788d-484c-aa76-7566187ac9df	1
https://web.fulcrumapp.com/photos/view?photos=3b0e99f0-a0d2-47da-a266-5bf7b79db0d4%2C088ece4e-e8b8-4098-a0d0-afe39afba19e	1
https://web.fulcrumapp.com/photos/view?photos=b59247a3-edc2-41ca-bc3b-3132bf43e6b5%2Cdd6db5b6-ce50-41e3-af76-d681608c1a3a%2Cd6ea6dbd-d107-47ba-b514-2ef62565985c	1
Other values (1115)	1115

Value	Count	Frequency (%)
https://web.fulcrumapp.com/photos/view?photos=4e04fc8e-8a18-48dd-9cbf-415f0e8e1dd7%2Cf6c190ef-0155-40b2-9645-30fc00894875%2C8158585b-a62f-4768-b02b-6bff1ee42e94%2C2aee37b3-5922-419c-be04-f13b6dbdb9ab	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=0270d4f5-1629-494d-8256-1b90b89f70e6%2C801addd2-e30f-4c43-a591-0488a8e5f142	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=1b5acd91-9efc-4e6f-bb38-26528a7539e6%2C83d08691-8a1a-4a67-9d67-0344268219ad%2C7634572f-46d1-4718-8e74-b7ff49f8e803%2Cdc246c20-788d-484c-aa76-7566187ac9df	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=3b0e99f0-a0d2-47da-a266-5bf7b79db0d4%2C088ece4e-e8b8-4098-a0d0-afe39afba19e	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=b59247a3-edc2-41ca-bc3b-3132bf43e6b5%2Cdd6db5b6-ce50-41e3-af76-d681608c1a3a%2Cd6ea6dbd-d107-47ba-b514-2ef62565985c	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=082093f1-1557-4ea8-957c-d6f078fce6db%2C7c251701-ec5a-44e6-8ede-046abb1fae04%2C0d82d32e-0fc6-452c-9579-34855cd0af6e%2C857de4d4-b9e2-4b0a-b391-ced1e07db8e4%2Cfe3156ec-bc4c-4522-86a5-837faa162864%2Cec795a63-09fd-4ca9-a355-e676c0aa9e19	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=ac6b8b2c-0195-4eb8-9aac-6df4a2dfdd42%2C98134f00-cb7e-4480-b8b2-fc9181e0ed6b%2Cebe3647d-15c6-478a-8514-ae76070332ec%2Cb71fc963-88c2-4690-bedb-ecfb1f6cac88%2C40ce9343-eca8-41ac-8a86-fec054e03d87%2Cbabb2cf7-eecf-4463-b8bb-612ea35bb1a9%2C7471ca16-947a-4ca9-a914-e2f8b5bb5bac%2C68b230c1-2554-42d7-8039-d697979525c9	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=4a23e3b8-2f3e-42be-a6ed-6f24705752a6%2Cd9633b9a-85c1-4237-a564-5748e6ec0db1%2Cc037e1a1-2ce7-4639-8af2-ce366b0b15b6%2Cbf993f27-0ab1-47b6-8d28-70930e8064fd%2C1de059a3-3e14-4dce-91aa-1eecc963da38%2C8473edfe-5b67-4ef6-be38-9fcb4b92607b%2C6517c646-facf-4f53-8d9b-a7758fadc4b1	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=6b3d09c9-9465-4ef9-b44c-0bd0a5d63530%2Cb4ee7b4a-0370-45d3-af53-9658dacb1082%2C3f2460d7-8570-4a66-83ee-b0a0ad47b2fc%2C7764d564-be5e-48b8-878f-83dfc87ebed1%2C3979d48e-513d-4a07-8087-00491e80d81c%2Cf45e8fe2-18b4-4aa7-a103-5004ee981cc4%2C0b41a410-ff46-4dcc-844f-7dc5f8006a7e%2Cad1d85fd-8b19-4dfc-b0e9-7ac31602c50d%2Cc0180e7d-e2c8-481c-a22c-7471a7b2d2e6%2C28960955-d436-44ed-b0a4-6d4257f05539%2C3a43bd56-0fae-4b44-8fcd-b60f73ca3caa	1	0.1%
https://web.fulcrumapp.com/photos/view?photos=e9d58d66-9d14-4201-8c42-2e2b6d65c061%2C63cfcc13-e876-4219-86eb-cf8a22a12ac5%2C114f7f95-a493-4ae1-9e35-4408a18a31b4	1	0.1%
Other values (1110)	1110	99.0%

Value	Count	Frequency (%)
https	1120	99.9%
(Missing)	1	0.1%

Value	Count	Frequency (%)
web.fulcrumapp.com	1120	99.9%
(Missing)	1	0.1%

Value	Count	Frequency (%)
/photos/view	1120	99.9%
(Missing)	1	0.1%

Value	Count	Frequency (%)
photos=81cc563b-1ade-4ae1-8843-637eafd35ebe%2Ce264e8f7-8f17-4b9e-8220-eccdb57566ae%2C81be6d36-ee3f-4bad-82ff-f0ee08d85c4a	1	0.1%
photos=b8594c27-fc28-44f5-a1b2-5fe583b0e430%2C0fa6cfc3-0293-4a58-86b3-66aeab8e4571%2C7cd5861f-321e-45cb-8453-af3802ccd6fc%2C431e57d4-c872-4c82-a8df-7a755b8b25ac%2C92404e50-eff2-41a4-98e8-f34b5d42a1ce	1	0.1%
photos=fc84a38b-5455-4c40-b196-884013e1965e%2Cd680b855-cbd9-40ff-ab93-446a9ce2c12e%2C5efad280-2b78-4b40-890f-a006aee692e9%2C2ab4e60c-651a-40a2-ae98-2ea82320a962%2C74522256-f7b4-4702-8e49-990649ce34c2	1	0.1%
photos=f7a9cf3c-61fd-4a00-a9fb-1d6eab955caf%2C17b493ca-0a26-4772-bae0-dbf523fc78cf	1	0.1%
photos=b68f157f-b83e-4845-bbe1-74f4c16dbdae%2C264076b0-facd-40d0-8114-4348cb47ee63	1	0.1%
photos=5b405156-363a-44da-a1bb-c4de16ffd555%2C35caea11-c41c-4f45-afc9-0aad17881971%2Cfd560607-f100-4878-9985-155d2fd51559%2C84eaa32b-7afe-460b-a944-95b1f38360e8	1	0.1%
photos=78e4f84c-c217-49e7-b39e-1b71cb7062c8%2C447c2070-8c92-4bb7-8e66-372adf9ed8a3%2Ca9bf9c8d-35ae-4dd3-8c92-b6a36bdfae96%2C277a5d37-8cdd-4029-97c3-9a3b62d4aa6e%2C4ca841e2-154c-4684-a722-cfda8f9e1ee5%2C71213e79-31bb-44ef-be0d-e4b452958464%2Cc8a0bdca-df2b-45ac-98a6-8442f1d92d31	1	0.1%
photos=db82ca31-91ad-490f-8276-e4d6ef4533e5%2C65bb80ba-7e78-4683-8941-241e7a0709b4%2Ccf9a3c18-8929-4512-a6ca-56060a8938db%2C68a5ee85-2b1a-498b-86f1-3416797f552a%2C8cc631fa-62b8-4e98-8cea-332333aaa72a	1	0.1%
photos=82179e9e-8944-466c-8a30-eeea4d272338%2C03f3fd67-955a-488d-bd37-3c9c129ad44d%2Cdc47447e-8105-432b-97f0-f990dc0d340f	1	0.1%
photos=3b392417-94b4-455e-93dd-fb73ab7598a0%2Cdbe9acd5-fe8d-48bb-82ec-d29a62ba4ff3%2C1e856be2-03bd-4fce-b444-9c742757357d%2C631c53ed-7b22-4112-a621-eb39beb47ce7	1	0.1%
Other values (1110)	1110	99.0%

Value	Count	Frequency (%)
	1120	99.9%
(Missing)	1	0.1%

overall_building_condition
Real number (ℝ_≥0)

ZEROS

Distinct count	5
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.511150758251561
Minimum	0
Maximum	4
Zeros	196
Zeros (%)	17.5%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.157317795
Coefficient of variation (CV)	0.7658519764
Kurtosis	-0.2259320897
Mean	1.511150758
Median Absolute Deviation (MAD)	1
Skewness	0.7102920696
Sum	1694
Variance	1.339384478

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	466	41.6%
2	253	22.6%
0	196	17.5%
4	104	9.3%
3	102	9.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	196	17.5%
1	466	41.6%
2	253	22.6%
3	102	9.1%
4	104	9.3%

Value	Count	Frequency (%)
4	104	9.3%
3	102	9.1%
2	253	22.6%
1	466	41.6%
0	196	17.5%

building_address_sub_thoroughfare
Categorical

HIGH CARDINALITY

Distinct count	835
Unique (%)	75.2%
Missing	11
Missing (%)	1.0%
Memory size	8.9 KiB

1180	26
55	17
8550	7
505	6
507	5
Other values (830)	1049

Value	Count	Frequency (%)
1180	26	2.3%
55	17	1.5%
8550	7	0.6%
505	6	0.5%
507	5	0.4%
10	5	0.4%
500	5	0.4%
760	4	0.4%
310	4	0.4%
350	4	0.4%
Other values (825)	1027	91.6%
(Missing)	11	1.0%

Length

Max length	13
Mean length	3.712756467
Min length	1

Value	Count	Frequency (%)
Decimal_Number	10	32.3%
Lowercase_Letter	9	29.0%
Uppercase_Letter	7	22.6%
Other_Punctuation	2	6.5%
Dash_Punctuation	1	3.2%
Control	1	3.2%
Space_Separator	1	3.2%

Value	Count	Frequency (%)
Latin	16	51.6%
Common	15	48.4%

Value	Count	Frequency (%)
ASCII	30	100.0%

building_address_thoroughfare
Categorical

HIGH CARDINALITY

Distinct count	357
Unique (%)	32.0%
Missing	4
Missing (%)	0.4%
Memory size	8.9 KiB

S Ponte Vedra Blvd	30
Magnolia Ct	24
Copeland Ave N	24
Chokoloskee Drive	24
Overseas Hwy	23
Other values (352)	992

Value	Count	Frequency (%)
S Ponte Vedra Blvd	30	2.7%
Magnolia Ct	24	2.1%
Copeland Ave N	24	2.1%
Chokoloskee Drive	24	2.1%
Overseas Hwy	23	2.1%
South Joy Circle	19	1.7%
Coconut Ave	18	1.6%
North Storter Avenue	17	1.5%
Nassau Road	16	1.4%
Boca Chica Rd	15	1.3%
Other values (347)	907	80.9%

Length

Max length	23
Mean length	12.09277431
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	25	41.0%
Uppercase_Letter	23	37.7%
Decimal_Number	10	16.4%
Space_Separator	1	1.6%
Other_Punctuation	1	1.6%
Dash_Punctuation	1	1.6%

Value	Count	Frequency (%)
Latin	48	78.7%
Common	13	21.3%

Value	Count	Frequency (%)
ASCII	61	100.0%

building_address_suite
Categorical

MISSING
UNIFORM

Distinct count	47
Unique (%)	85.5%
Missing	1066
Missing (%)	95.1%
Memory size	8.9 KiB

Summerhouse Condos	5
18	2
27	2
24	2
Units #1-4	2
Other values (42)	42

Value	Count	Frequency (%)
Summerhouse Condos	5	0.4%
18	2	0.2%
27	2	0.2%
24	2	0.2%
Units #1-4	2	0.2%
Unit #7	1	0.1%
Lot 432	1	0.1%
50	1	0.1%
Unit #3	1	0.1%
B-110, B-111	1	0.1%
Other values (37)	37	3.3%
(Missing)	1066	95.1%

Length

Max length	26
Mean length	3.203389831
Min length	1

Value	Count	Frequency (%)
Lowercase_Letter	17	42.5%
Decimal_Number	10	25.0%
Uppercase_Letter	8	20.0%
Other_Punctuation	3	7.5%
Space_Separator	1	2.5%
Dash_Punctuation	1	2.5%

Value	Count	Frequency (%)
Latin	25	62.5%
Common	15	37.5%

Value	Count	Frequency (%)
ASCII	40	100.0%

building_address_locality
Categorical

HIGH CARDINALITY

Distinct count	52
Unique (%)	4.6%
Missing	2
Missing (%)	0.2%
Memory size	8.9 KiB

Marco Island	213
Big Pine Key	118
Naples	101
Little Torch Key	90
Everglades City	78
Other values (47)	519

Value	Count	Frequency (%)
Marco Island	213	19.0%
Big Pine Key	118	10.5%
Naples	101	9.0%
Little Torch Key	90	8.0%
Everglades City	78	7.0%
Goodland	63	5.6%
Marathon	61	5.4%
Ramrod Key	51	4.5%
Cudjoe Key	51	4.5%
Key West	35	3.1%
Other values (42)	258	23.0%

Length

Max length	19
Mean length	11.22747547
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	22	50.0%
Uppercase_Letter	20	45.5%
Space_Separator	1	2.3%
Other_Punctuation	1	2.3%

Value	Count	Frequency (%)
Latin	42	95.5%
Common	2	4.5%

Value	Count	Frequency (%)
ASCII	44	100.0%

building_address_sub_admin_area
Categorical

Distinct count	9
Unique (%)	0.8%
Missing	2
Missing (%)	0.2%
Memory size	8.9 KiB

Monroe	542
Collier	502
St. Johns	44
Miami-Dade	19
Brevard	7
Other values (4)	5

Value	Count	Frequency (%)
Monroe	542	48.3%
Collier	502	44.8%
St. Johns	44	3.9%
Miami-Dade	19	1.7%
Brevard	7	0.6%
Lee	2	0.2%
Naples	1	0.1%
Palm Beach	1	0.1%
Okeechobee	1	0.1%
(Missing)	2	0.2%

Length

Max length	10
Mean length	6.636039251
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	17	56.7%
Uppercase_Letter	10	33.3%
Space_Separator	1	3.3%
Other_Punctuation	1	3.3%
Dash_Punctuation	1	3.3%

Value	Count	Frequency (%)
Latin	27	90.0%
Common	3	10.0%

Value	Count	Frequency (%)
ASCII	30	100.0%

building_address_admin_area
Categorical

Distinct count	3
Unique (%)	0.3%
Missing	4
Missing (%)	0.4%
Memory size	8.9 KiB

FL	639
Florida	476
Florida	2

Value	Count	Frequency (%)
FL	639	57.0%
Florida	476	42.5%
Florida	2	0.2%
(Missing)	4	0.4%

Length

Max length	8
Mean length	4.137377342
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	7	70.0%
Uppercase_Letter	2	20.0%
Space_Separator	1	10.0%

Value	Count	Frequency (%)
Latin	9	90.0%
Common	1	10.0%

Value	Count	Frequency (%)
ASCII	10	100.0%

building_address_postal_code
Real number (ℝ_≥0)

Distinct count	42
Unique (%)	3.8%
Missing	8
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	33501.743935309976
Minimum	31439.0
Maximum	34974.0
Zeros	0
Zeros (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	31439
5-th percentile	33036
Q1	33042
median	33050
Q3	34140
95-th percentile	34145
Maximum	34974
Range	3535
Interquartile range (IQR)	1098

Descriptive statistics

Standard deviation	604.7670445
Coefficient of variation (CV)	0.01805180786
Kurtosis	-1.057291007
Mean	33501.74394
Median Absolute Deviation (MAD)	95
Skewness	-0.184942474
Sum	37287441
Variance	365743.1781

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
33042	254	22.7%
34145	214	19.1%
33043	118	10.5%
33050	81	7.2%
34139	78	7.0%
34140	66	5.9%
33040	59	5.3%
34113	58	5.2%
34138	38	3.4%
33036	24	2.1%
Other values (32)	123	11.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
31439	1	0.1%
32080	16	1.4%
32082	23	2.1%
32802	4	0.4%
32905	2	0.2%

Value	Count	Frequency (%)
34974	1	0.1%
34145	214	19.1%
34141	1	0.1%
34140	66	5.9%
34139	78	7.0%

building_address_country
Categorical

MISSING

Distinct count	5
Unique (%)	0.5%
Missing	29
Missing (%)	2.6%
Memory size	8.9 KiB

US	685
United States	307
USA	85
Estados Unidos	14
Florida	1

Value	Count	Frequency (%)
US	685	61.1%
United States	307	27.4%
USA	85	7.6%
Estados Unidos	14	1.2%
Florida	1	0.1%
(Missing)	29	2.6%

Length

Max length	14
Mean length	5.268510259
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	10	62.5%
Uppercase_Letter	5	31.2%
Space_Separator	1	6.2%

Value	Count	Frequency (%)
Latin	15	93.8%
Common	1	6.2%

Value	Count	Frequency (%)
ASCII	16	100.0%

building_address_full
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1101
Unique (%)	98.4%
Missing	2
Missing (%)	0.2%
Memory size	8.9 KiB

8550 A1A S Summerhouse Condos St. Augustine St. John's Florida 32080 USA	3
701??799 4th St Key West Monroe FL 33040 US	2
22 Beach Dr Key West Monroe FL 33040 US	2
760 La Fitte Rd Little Torch Key Monroe FL 33042 US	2
3444 N Roosevelt Blvd Key West Monroe FL 33040 US	2
Other values (1096)	1108

Value	Count	Frequency (%)
8550 A1A S Summerhouse Condos St. Augustine St. John's Florida 32080 USA	3	0.3%
701??799 4th St Key West Monroe FL 33040 US	2	0.2%
22 Beach Dr Key West Monroe FL 33040 US	2	0.2%
760 La Fitte Rd Little Torch Key Monroe FL 33042 US	2	0.2%
3444 N Roosevelt Blvd Key West Monroe FL 33040 US	2	0.2%
26??30 Arapaho Trl Naples Collier FL 34113 US	2	0.2%
71 W Indies Dr Ramrod Key Monroe FL 33042 US	2	0.2%
350 7th Street N Naples Collier FL 34102 US	2	0.2%
11001 Overseas Hwy Marathon Monroe FL 33050 US	2	0.2%
817 Magnolia Ct Marco Island Collier FL 34145 US	2	0.2%
Other values (1091)	1098	97.9%

Length

Max length	96
Mean length	54.24799286
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	25	37.3%
Uppercase_Letter	23	34.3%
Decimal_Number	10	14.9%
Other_Punctuation	6	9.0%
Control	1	1.5%
Dash_Punctuation	1	1.5%
Space_Separator	1	1.5%

Value	Count	Frequency (%)
Latin	48	71.6%
Common	19	28.4%

Value	Count	Frequency (%)
ASCII	66	100.0%

assessment_type
Categorical

MISSING

Distinct count	10
Unique (%)	0.9%
Missing	40
Missing (%)	3.6%
Memory size	8.9 KiB

Single Family Residence	841
Mobile Home	164
Apartment / Condo	31
Utilities	17
Church	8
Other values (5)	20

Value	Count	Frequency (%)
Single Family Residence	841	75.0%
Mobile Home	164	14.6%
Apartment / Condo	31	2.8%
Utilities	17	1.5%
Church	8	0.7%
Retail Store	7	0.6%
Hotel / Motel	6	0.5%
Restaurant	3	0.3%
Industrial	2	0.2%
Hospital	2	0.2%
(Missing)	40	3.6%

Length

Max length	23
Mean length	19.82426405
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	18	62.1%
Uppercase_Letter	9	31.0%
Space_Separator	1	3.4%
Other_Punctuation	1	3.4%

Value	Count	Frequency (%)
Latin	27	93.1%
Common	2	6.9%

Value	Count	Frequency (%)
ASCII	29	100.0%

assessment_type_other
Categorical

MISSING

Distinct count	29
Unique (%)	72.5%
Missing	1081
Missing (%)	96.4%
Memory size	8.9 KiB

Gravestone	5
Multiple Family Residence	4
RV	3
Marina	3
Traffic sign	1
Other values (24)	24

Value	Count	Frequency (%)
Gravestone	5	0.4%
Multiple Family Residence	4	0.4%
RV	3	0.3%
Marina	3	0.3%
Traffic sign	1	0.1%
Cemetery Office	1	0.1%
Gas station	1	0.1%
Wooden bridge	1	0.1%
Gas station canopy	1	0.1%
Radio tower	1	0.1%
Other values (19)	19	1.7%
(Missing)	1081	96.4%

Length

Max length	25
Mean length	3.330062444
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	21	60.0%
Uppercase_Letter	13	37.1%
Space_Separator	1	2.9%

Value	Count	Frequency (%)
Latin	34	97.1%
Common	1	2.9%

Value	Count	Frequency (%)
ASCII	35	100.0%

year_built
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count	81
Unique (%)	7.8%
Missing	81
Missing (%)	7.2%
Infinite	0
Infinite (%)	0.0%

Mean	1981.2615384615385
Minimum	0.0
Maximum	2018.0
Zeros	1
Zeros (%)	0.1%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1949.95
Q1	1973
median	1985
Q3	1996
95-th percentile	2009
Maximum	2018
Range	2018
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	64.27340888
Coefficient of variation (CV)	0.03244064836
Kurtosis	871.0647952
Mean	1981.261538
Median Absolute Deviation (MAD)	12
Skewness	-28.25839657
Sum	2060512
Variance	4131.071089

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1985	39	3.5%
1987	35	3.1%
1990	33	2.9%
1986	31	2.8%
1977	27	2.4%
1980	25	2.2%
1988	24	2.1%
2000	23	2.1%
1983	23	2.1%
1984	22	2.0%
Other values (71)	758	67.6%
(Missing)	81	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1913	1	0.1%
1925	19	1.7%
1926	1	0.1%
1930	7	0.6%

Value	Count	Frequency (%)
2018	1	0.1%
2017	8	0.7%
2016	13	1.2%
2015	6	0.5%
2014	5	0.4%

effective_year_built
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count	79
Unique (%)	8.1%
Missing	145
Missing (%)	12.9%
Infinite	0
Infinite (%)	0.0%

Mean	1988.3401639344263
Minimum	0.0
Maximum	2017.0
Zeros	1
Zeros (%)	0.1%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1953
Q1	1982
median	1995
Q3	2003
95-th percentile	2012
Maximum	2017
Range	2017
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	66.26039592
Coefficient of variation (CV)	0.03332447693
Kurtosis	833.8052407
Mean	1988.340164
Median Absolute Deviation (MAD)	9
Skewness	-27.79443758
Sum	1940620
Variance	4390.440067

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2003	51	4.5%
2000	49	4.4%
1995	41	3.7%
1997	38	3.4%
2005	35	3.1%
1998	31	2.8%
1999	31	2.8%
2002	26	2.3%
2007	25	2.2%
1989	24	2.1%
Other values (69)	625	55.8%
(Missing)	145	12.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1913	1	0.1%
1925	12	1.1%
1926	1	0.1%
1930	6	0.5%

Value	Count	Frequency (%)
2017	8	0.7%
2016	11	1.0%
2015	9	0.8%
2014	6	0.5%
2013	7	0.6%

number_of_stories
Real number (ℝ_≥0)

MISSING

Distinct count	11
Unique (%)	1.0%
Missing	57
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.3073308270676691
Minimum	0.0
Maximum	19.0
Zeros	1
Zeros (%)	0.1%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9178397167
Coefficient of variation (CV)	0.7020715015
Kurtosis	166.4985378
Mean	1.307330827
Median Absolute Deviation (MAD)	0
Skewness	10.28661791
Sum	1391
Variance	0.8424297456

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	827	73.8%
2	187	16.7%
3	33	2.9%
5	7	0.6%
1.5	4	0.4%
19	1	0.1%
6	1	0.1%
0	1	0.1%
7	1	0.1%
14	1	0.1%
(Missing)	57	5.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	827	73.8%
1.5	4	0.4%
2	187	16.7%
3	33	2.9%

Value	Count	Frequency (%)
19	1	0.1%
14	1	0.1%
7	1	0.1%
6	1	0.1%
5	7	0.6%

roof_shape
Categorical

MISSING

Distinct count	15
Unique (%)	1.4%
Missing	53
Missing (%)	4.7%
Memory size	8.9 KiB

Gable	532
Hip	193
Complex	121
Flat	81
Hip/Gable	63
Other values (10)	78

Value	Count	Frequency (%)
Gable	532	47.5%
Hip	193	17.2%
Complex	121	10.8%
Flat	81	7.2%
Hip/Gable	63	5.6%
Hip,Complex	50	4.5%
Gable,Complex	8	0.7%
Gable,Flat	5	0.4%
Other	5	0.4%
Hip/Gable,Complex	3	0.3%
Other values (5)	7	0.6%
(Missing)	53	4.7%

Length

Max length	17
Mean length	5.332738626
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	13	65.0%
Uppercase_Letter	5	25.0%
Other_Punctuation	2	10.0%

Value	Count	Frequency (%)
Latin	18	90.0%
Common	2	10.0%

Value	Count	Frequency (%)
ASCII	20	100.0%

roof_shape_other
Categorical

MISSING

Distinct count	7
Unique (%)	70.0%
Missing	1111
Missing (%)	99.1%
Memory size	8.9 KiB

Mansard	3
Rounded	2
Flat roof in the center with sloping gables on two sides	1
First floor gable, upper floor monoslope	1
geodesic dome	1
Other values (2)	2

Value	Count	Frequency (%)
Mansard	3	0.3%
Rounded	2	0.2%
Flat roof in the center with sloping gables on two sides	1	0.1%
First floor gable, upper floor monoslope	1	0.1%
geodesic dome	1	0.1%
Mansard roof	1	0.1%
Gable/Flat	1	0.1%
(Missing)	1111	99.1%

Length

Max length	56
Mean length	3.12132025
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	19	73.1%
Uppercase_Letter	4	15.4%
Other_Punctuation	2	7.7%
Space_Separator	1	3.8%

Value	Count	Frequency (%)
Latin	23	88.5%
Common	3	11.5%

Value	Count	Frequency (%)
ASCII	26	100.0%

roof_cover
Categorical

MISSING

Distinct count	11
Unique (%)	1.1%
Missing	136
Missing (%)	12.1%
Memory size	8.9 KiB

Standing Seam Metal	297
Asphalt shingles (3-tab)	222
Asphalt shingles (laminated)	171
Tile (clay)	131
Corrugated metal	58
Other values (6)	106

Value	Count	Frequency (%)
Standing Seam Metal	297	26.5%
Asphalt shingles (3-tab)	222	19.8%
Asphalt shingles (laminated)	171	15.3%
Tile (clay)	131	11.7%
Corrugated metal	58	5.2%
Metal shingle	44	3.9%
EPDM rubber roof	32	2.9%
Tile (concrete)	27	2.4%
Asphalt shingles (laminated),EPDM rubber roof	1	0.1%
0%	1	0.1%
(Missing)	136	12.1%

Length

Max length	45
Mean length	17.94469224
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	19	54.3%
Uppercase_Letter	8	22.9%
Decimal_Number	2	5.7%
Other_Punctuation	2	5.7%
Close_Punctuation	1	2.9%
Open_Punctuation	1	2.9%
Dash_Punctuation	1	2.9%
Space_Separator	1	2.9%

Value	Count	Frequency (%)
Latin	27	77.1%
Common	8	22.9%

Value	Count	Frequency (%)
ASCII	35	100.0%

roof_cover_other
Categorical

MISSING

Distinct count	32
Unique (%)	42.7%
Missing	1046
Missing (%)	93.3%
Memory size	8.9 KiB

Unknown	22
Metal	13
Tar & Gravel	5
Asphalt composite shingle	2
Tar and Gravel	2
Other values (27)	31

Value	Count	Frequency (%)
Unknown	22	2.0%
Metal	13	1.2%
Tar & Gravel	5	0.4%
Asphalt composite shingle	2	0.2%
Tar and Gravel	2	0.2%
Rolled Composite Roofing	2	0.2%
unknown	2	0.2%
pvc	2	0.2%
TAR & GRAVEL	2	0.2%
Looks like asphalt shingle (3-tab) from aerial photograph	1	0.1%
Other values (22)	22	2.0%
(Missing)	1046	93.3%

Length

Max length	57
Mean length	3.599464764
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	22	47.8%
Uppercase_Letter	16	34.8%
Other_Punctuation	2	4.3%
Dash_Punctuation	1	2.2%
Decimal_Number	1	2.2%
Close_Punctuation	1	2.2%
Open_Punctuation	1	2.2%
Space_Separator	1	2.2%
Math_Symbol	1	2.2%

Value	Count	Frequency (%)
Latin	38	82.6%
Common	8	17.4%

Value	Count	Frequency (%)
ASCII	46	100.0%

wall_cladding
Categorical

MISSING

Distinct count	19
Unique (%)	1.8%
Missing	90
Missing (%)	8.0%
Memory size	8.9 KiB

Stucco	405
Vinyl siding	334
Wood plank siding	89
Wood panel siding	83
Sheet metal	64
Other values (14)	56

Value	Count	Frequency (%)
Stucco	405	36.1%
Vinyl siding	334	29.8%
Wood plank siding	89	7.9%
Wood panel siding	83	7.4%
Sheet metal	64	5.7%
EIFS	11	1.0%
Stucco,Vinyl siding	9	0.8%
Stucco,Wood panel siding	8	0.7%
Stucco,Wood plank siding	8	0.7%
Wood plank siding,EIFS	5	0.4%
Other values (9)	15	1.3%
(Missing)	90	8.0%

Length

Max length	42
Mean length	10.16859946
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	19	67.9%
Uppercase_Letter	7	25.0%
Space_Separator	1	3.6%
Other_Punctuation	1	3.6%

Value	Count	Frequency (%)
Latin	26	92.9%
Common	2	7.1%

Value	Count	Frequency (%)
ASCII	28	100.0%

wall_cladding_other
Categorical

MISSING

Distinct count	14
Unique (%)	35.0%
Missing	1081
Missing (%)	96.4%
Memory size	8.9 KiB

Unknown	18
Concrete Siding	6
Wood shingle	3
Hardiboard	2
Hardie Board	2
Other values (9)	9

Value	Count	Frequency (%)
Unknown	18	1.6%
Concrete Siding	6	0.5%
Wood shingle	3	0.3%
Hardiboard	2	0.2%
Hardie Board	2	0.2%
Heavy Stone	1	0.1%
Unkwnonw	1	0.1%
Stucco & wood paneling	1	0.1%
Tile	1	0.1%
Concrete STUCCO	1	0.1%
Other values (4)	4	0.4%
(Missing)	1081	96.4%

Length

Max length	22
Mean length	3.262265834
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	22	66.7%
Uppercase_Letter	9	27.3%
Space_Separator	1	3.0%
Other_Punctuation	1	3.0%

Value	Count	Frequency (%)
Latin	31	93.9%
Common	2	6.1%

Value	Count	Frequency (%)
ASCII	33	100.0%

first_floor_elevation_ft
Real number (ℝ_≥0)

ZEROS

Distinct count	22
Unique (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.29014272970562
Minimum	0.0
Maximum	14.0
Zeros	513
Zeros (%)	45.8%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1.75
Q3	8
95-th percentile	10
Maximum	14
Range	14
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.939250583
Coefficient of variation (CV)	1.197288661
Kurtosis	-1.05023717
Mean	3.29014273
Median Absolute Deviation (MAD)	1.75
Skewness	0.7395883424
Sum	3688.25
Variance	15.51769516

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	513	45.8%
8	229	20.4%
2	112	10.0%
9	52	4.6%
10	41	3.7%
1	36	3.2%
1.75	29	2.6%
3	25	2.2%
12	24	2.1%
2.25	14	1.2%
Other values (12)	46	4.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	513	45.8%
1	36	3.2%
1.5	6	0.5%
1.75	29	2.6%
2	112	10.0%

Value	Count	Frequency (%)
14	4	0.4%
13	1	0.1%
12	24	2.1%
11	3	0.3%
10	41	3.7%

other_details
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	99
Unique (%)	95.2%
Missing	1017
Missing (%)	90.7%
Memory size	8.9 KiB

1. 1st floor: Stucco; 2nd floor: Wood panel.	4
1. Roof cover not visible in photographs.	2
Shingles old	2
Timber frame on top of concret piers and slab	1
1. 2ft water mark above ground level 2. Wall Cladding: 1st floor Brick Veneer, 2nd floor Vinyl Siding	1
Other values (94)	94

Value	Count	Frequency (%)
1. 1st floor: Stucco; 2nd floor: Wood panel.	4	0.4%
1. Roof cover not visible in photographs.	2	0.2%
Shingles old	2	0.2%
Timber frame on top of concret piers and slab	1	0.1%
1. 2ft water mark above ground level 2. Wall Cladding: 1st floor Brick Veneer, 2nd floor Vinyl Siding	1	0.1%
Screen damage	1	0.1%
Timber roof on masonry structure. Steel frame supports the ground kitchen floor	1	0.1%
Impact-Resistant Roof	1	0.1%
Stairway leads to an elevated first floor. Porch along two sides of the house.	1	0.1%
1. Roof cover not visible.	1	0.1%
Other values (89)	89	7.9%
(Missing)	1017	90.7%

Length

Max length	318
Mean length	7.694915254
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	24	35.8%
Uppercase_Letter	21	31.3%
Decimal_Number	10	14.9%
Other_Punctuation	7	10.4%
Dash_Punctuation	1	1.5%
Control	1	1.5%
Open_Punctuation	1	1.5%
Space_Separator	1	1.5%
Close_Punctuation	1	1.5%

Value	Count	Frequency (%)
Latin	45	67.2%
Common	22	32.8%

Value	Count	Frequency (%)
ASCII	67	100.0%

structural_framing_system
Categorical

MISSING

Distinct count	20
Unique (%)	1.9%
Missing	89
Missing (%)	7.9%
Memory size	8.9 KiB

Unknown	442
Wood-frame	330
Masonry block (unknown reinforcement)	169
Wood-frame,Reinforced concrete	28
Wood-frame,Masonry block (unknown reinforcement)	21
Other values (15)	42

Value	Count	Frequency (%)
Unknown	442	39.4%
Wood-frame	330	29.4%
Masonry block (unknown reinforcement)	169	15.1%
Wood-frame,Reinforced concrete	28	2.5%
Wood-frame,Masonry block (unknown reinforcement)	21	1.9%
Reinforced concrete	10	0.9%
Masonry block (reinforced),Reinforced concrete	8	0.7%
Structural steel	6	0.5%
Masonry block (reinforced)	3	0.3%
Wood-frame,Reinforced masonry block	3	0.3%
Other values (10)	12	1.1%
(Missing)	89	7.9%

Length

Max length	57
Mean length	14.27832293
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	18	62.1%
Uppercase_Letter	6	20.7%
Dash_Punctuation	1	3.4%
Close_Punctuation	1	3.4%
Open_Punctuation	1	3.4%
Space_Separator	1	3.4%
Other_Punctuation	1	3.4%

Value	Count	Frequency (%)
Latin	24	82.8%
Common	5	17.2%

Value	Count	Frequency (%)
ASCII	29	100.0%

structural_framing_system_other
Categorical

MISSING

Distinct count	12
Unique (%)	54.5%
Missing	1099
Missing (%)	98.0%
Memory size	8.9 KiB

Metal/Aluminium	11
Concrete columns at first floor	1
Prestressed concrete poles	1
RC elevated platform	1
concrete piers	1
Other values (7)	7

Value	Count	Frequency (%)
Metal/Aluminium	11	1.0%
Concrete columns at first floor	1	0.1%
Prestressed concrete poles	1	0.1%
RC elevated platform	1	0.1%
concrete piers	1	0.1%
Concrete columns	1	0.1%
dome elevated on wood piers	1	0.1%
Metal	1	0.1%
ICF	1	0.1%
concrete block piers	1	0.1%
Other values (2)	2	0.2%
(Missing)	1099	98.0%

Length

Max length	31
Mean length	3.264942016
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	19	57.6%
Uppercase_Letter	8	24.2%
Other_Punctuation	3	9.1%
Decimal_Number	2	6.1%
Space_Separator	1	3.0%

Value	Count	Frequency (%)
Latin	27	81.8%
Common	6	18.2%

Value	Count	Frequency (%)
ASCII	33	100.0%

roof_sheathing_nail_spacing
Categorical

MISSING

Distinct count	2
Unique (%)	18.2%
Missing	1110
Missing (%)	99.0%
Memory size	8.9 KiB

6:12	9
6:06	2

Value	Count	Frequency (%)
6:12	9	0.8%
6:06	2	0.2%
(Missing)	1110	99.0%

Length

Max length	4
Mean length	3.009812667
Min length	3

Value	Count	Frequency (%)
Decimal_Number	4	57.1%
Lowercase_Letter	2	28.6%
Other_Punctuation	1	14.3%

Value	Count	Frequency (%)
Common	5	71.4%
Latin	2	28.6%

Value	Count	Frequency (%)
ASCII	7	100.0%

roof_sheathing_nail_size
Categorical

Distinct count	2
Unique (%)	0.2%
Missing	1
Missing (%)	0.1%
Memory size	8.9 KiB

Unknown	1119
8D (2-1/2" long	1

Value	Count	Frequency (%)
Unknown	1119	99.8%
8D (2-1/2" long	1	0.1%
(Missing)	1	0.1%

Length

Max length	15
Mean length	7.003568243
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	7	41.2%
Decimal_Number	3	17.6%
Uppercase_Letter	2	11.8%
Other_Punctuation	2	11.8%
Open_Punctuation	1	5.9%
Dash_Punctuation	1	5.9%
Space_Separator	1	5.9%

Value	Count	Frequency (%)
Latin	9	52.9%
Common	8	47.1%

Value	Count	Frequency (%)
ASCII	17	100.0%

roof_sheathing_nail_size_other
Categorical

MISSING

Distinct count	1
Unique (%)	100.0%
Missing	1120
Missing (%)	99.9%
Memory size	8.9 KiB

Staples!	1

Value	Count	Frequency (%)
Staples!	1	0.1%
(Missing)	1120	99.9%

Length

Max length	8
Mean length	3.004460303
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	7	77.8%
Other_Punctuation	1	11.1%
Uppercase_Letter	1	11.1%

Value	Count	Frequency (%)
Latin	8	88.9%
Common	1	11.1%

Value	Count	Frequency (%)
ASCII	9	100.0%

roof_to_wall_connection
Categorical

MISSING

Distinct count	5
Unique (%)	1.0%
Missing	631
Missing (%)	56.3%
Memory size	8.9 KiB

Unknown	466
"e.g., H2.5"	11
wraps around truss	10
Toe-nail	2
wraps around truss,Toe-nail	1

Value	Count	Frequency (%)
Unknown	466	41.6%
"e.g., H2.5"	11	1.0%
wraps around truss	10	0.9%
Toe-nail	2	0.2%
wraps around truss,Toe-nail	1	0.1%
(Missing)	631	56.3%

Length

Max length	27
Mean length	4.915254237
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	15	60.0%
Uppercase_Letter	3	12.0%
Other_Punctuation	3	12.0%
Decimal_Number	2	8.0%
Space_Separator	1	4.0%
Dash_Punctuation	1	4.0%

Value	Count	Frequency (%)
Latin	18	72.0%
Common	7	28.0%

Value	Count	Frequency (%)
ASCII	25	100.0%

roof_to_wall_connection_other
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1121
Missing (%)	100.0%
Memory size	8.9 KiB

opening_protection
Categorical

MISSING

Distinct count	8
Unique (%)	1.0%
Missing	285
Missing (%)	25.4%
Memory size	8.9 KiB

None	373
Shutters	363
Impact-resistant glass	54
Plywood/OSB	34
Shutters,Plywood/OSB	6
Other values (3)	6

Value	Count	Frequency (%)
None	373	33.3%
Shutters	363	32.4%
Impact-resistant glass	54	4.8%
Plywood/OSB	34	3.0%
Shutters,Plywood/OSB	6	0.5%
Shutters,Impact-resistant glass	4	0.4%
Plywood/OSB,Shutters	1	0.1%
Impact-resistant glass,Shutters	1	0.1%
(Missing)	285	25.4%

Length

Max length	31
Mean length	6.340767172
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	18	64.3%
Uppercase_Letter	6	21.4%
Other_Punctuation	2	7.1%
Space_Separator	1	3.6%
Dash_Punctuation	1	3.6%

Value	Count	Frequency (%)
Latin	24	85.7%
Common	4	14.3%

Value	Count	Frequency (%)
ASCII	28	100.0%

opening_protection_other
Categorical

MISSING

Distinct count	10
Unique (%)	15.4%
Missing	1056
Missing (%)	94.2%
Memory size	8.9 KiB

Unknown	48
unknown	9
home made	1
Wood planks nailed centered at 4in. along the width of windows. Glass still exposed.	1
Wood planks nailed every 8in along the width of the windows	1
Other values (5)	5

Value	Count	Frequency (%)
Unknown	48	4.3%
unknown	9	0.8%
home made	1	0.1%
Wood planks nailed centered at 4in. along the width of windows. Glass still exposed.	1	0.1%
Wood planks nailed every 8in along the width of the windows	1	0.1%
Uknown	1	0.1%
Canvas material	1	0.1%
Unknowon	1	0.1%
Decorative iron cages.	1	0.1%
Other	1	0.1%
(Missing)	1056	94.2%

Length

Max length	84
Mean length	3.368421053
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	22	68.8%
Uppercase_Letter	6	18.8%
Decimal_Number	2	6.2%
Space_Separator	1	3.1%
Other_Punctuation	1	3.1%

Value	Count	Frequency (%)
Latin	28	87.5%
Common	4	12.5%

Value	Count	Frequency (%)
ASCII	32	100.0%

garage_door
Boolean

MISSING

Distinct count	2
Unique (%)	0.2%
Missing	95
Missing (%)	8.5%
Memory size	8.9 KiB

no	689
yes	337
(Missing)	95

Frequency Table

Value	Count	Frequency (%)
no	689	61.5%
yes	337	30.1%
(Missing)	95	8.5%

garage_door_location
Categorical

MISSING

Distinct count	3
Unique (%)	2.5%
Missing	1002
Missing (%)	89.4%
Memory size	8.9 KiB

Either side of the windward wall	46
Facing the oncoming wind	40
Opposite side of the windward	33

Value	Count	Frequency (%)
Either side of the windward wall	46	4.1%
Facing the oncoming wind	40	3.6%
Opposite side of the windward	33	2.9%
(Missing)	1002	89.4%

Length

Max length	32
Mean length	5.704727921
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	17	81.0%
Uppercase_Letter	3	14.3%
Space_Separator	1	4.8%

Value	Count	Frequency (%)
Latin	20	95.2%
Common	1	4.8%

Value	Count	Frequency (%)
ASCII	21	100.0%

garage_door_failure
Categorical

MISSING

Distinct count	3
Unique (%)	0.9%
Missing	770
Missing (%)	68.7%
Memory size	8.9 KiB

No	284
Unknown	37
Yes	30

Value	Count	Frequency (%)
No	284	25.3%
Unknown	37	3.3%
Yes	30	2.7%
(Missing)	770	68.7%

Length

Max length	7
Mean length	2.87867975
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	7	70.0%
Uppercase_Letter	3	30.0%

Value	Count	Frequency (%)
Latin	10	100.0%

Value	Count	Frequency (%)
ASCII	10	100.0%

other_structural_details
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	73
Unique (%)	90.1%
Missing	1040
Missing (%)	92.8%
Memory size	8.9 KiB

1. Impact glass assumed from photos.	3
1. 1st floor: RC columns; 2nd floor: Wood-frame.	3
1. Structural Framing: 1st floor RC, 2nd floor Wood-frame	2
1. 1st floor: RC; 2nd floor: Wood-frame.	2
1. RC framing system with reinforced CMU likely.	2
Other values (68)	69

Value	Count	Frequency (%)
1. Impact glass assumed from photos.	3	0.3%
1. 1st floor: RC columns; 2nd floor: Wood-frame.	3	0.3%
1. Structural Framing: 1st floor RC, 2nd floor Wood-frame	2	0.2%
1. 1st floor: RC; 2nd floor: Wood-frame.	2	0.2%
1. RC framing system with reinforced CMU likely.	2	0.2%
1. RC framing with reinforced CMU likely.	2	0.2%
1. Only one window shows shutter protection in photographs.	1	0.1%
The structure is mainly of concrete block, but it was later enclosed with wood frame.	1	0.1%
1. No opening protection visible.	1	0.1%
Owner think might be due to tornado	1	0.1%
Other values (63)	63	5.6%
(Missing)	1040	92.8%

Length

Max length	173
Mean length	6.807314897
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	24	39.3%
Uppercase_Letter	18	29.5%
Decimal_Number	7	11.5%
Other_Punctuation	7	11.5%
Control	1	1.6%
Open_Punctuation	1	1.6%
Dash_Punctuation	1	1.6%
Close_Punctuation	1	1.6%
Space_Separator	1	1.6%

Value	Count	Frequency (%)
Latin	42	68.9%
Common	19	31.1%

Value	Count	Frequency (%)
ASCII	61	100.0%

damage_modes
Categorical

MISSING

Distinct count	13
Unique (%)	1.3%
Missing	149
Missing (%)	13.3%
Memory size	8.9 KiB

Wind	817
Wind,Surge	89
Surge	32
Wind,Tree	11
Wind,Flood,Surge	5
Other values (8)	18

Value	Count	Frequency (%)
Wind	817	72.9%
Wind,Surge	89	7.9%
Surge	32	2.9%
Wind,Tree	11	1.0%
Wind,Flood,Surge	5	0.4%
Surge,Wind	4	0.4%
Wind,Flood	4	0.4%
Tree	3	0.3%
Wind,Surge,Tree	2	0.2%
Flood,Surge	2	0.2%
Other values (3)	3	0.3%
(Missing)	149	13.3%

Length

Max length	16
Mean length	4.571810883
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	10	66.7%
Uppercase_Letter	4	26.7%
Other_Punctuation	1	6.7%

Value	Count	Frequency (%)
Latin	14	93.3%
Common	1	6.7%

Value	Count	Frequency (%)
ASCII	15	100.0%

damage_modes_other
Categorical

MISSING

Distinct count	7
Unique (%)	87.5%
Missing	1113
Missing (%)	99.3%
Memory size	8.9 KiB

Other	2
Rain	1
Soil failure	1
scouring	1
Wind and Debris	1
Other values (2)	2

Value	Count	Frequency (%)
Other	2	0.2%
Rain	1	0.1%
Soil failure	1	0.1%
scouring	1	0.1%
Wind and Debris	1	0.1%
Boot hit the bridge during the storm	1	0.1%
Unknown	1	0.1%
(Missing)	1113	99.3%

Length

Max length	36
Mean length	3.062444246
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	19	70.4%
Uppercase_Letter	7	25.9%
Space_Separator	1	3.7%

Value	Count	Frequency (%)
Latin	26	96.3%
Common	1	3.7%

Value	Count	Frequency (%)
ASCII	27	100.0%

number_of_sides_used
Real number (ℝ_≥0)

MISSING

Distinct count	5
Unique (%)	0.5%
Missing	86
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%

Mean	2.2483091787439613
Minimum	0.0
Maximum	4.0
Zeros	5
Zeros (%)	0.4%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.989883324
Coefficient of variation (CV)	0.4402790032
Kurtosis	-0.8734598449
Mean	2.248309179
Median Absolute Deviation (MAD)	1
Skewness	0.2601457513
Sum	2327
Variance	0.9798689952

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	375	33.5%
1	261	23.3%
3	260	23.2%
4	134	12.0%
0	5	0.4%
(Missing)	86	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	0.4%
1	261	23.3%
2	375	33.5%
3	260	23.2%
4	134	12.0%

Value	Count	Frequency (%)
4	134	12.0%
3	260	23.2%
2	375	33.5%
1	261	23.3%
0	5	0.4%

damage_visible_in_photos
Boolean

MISSING

Distinct count	2
Unique (%)	0.2%
Missing	79
Missing (%)	7.0%
Memory size	8.9 KiB

yes	923
no	119
(Missing)	79

Frequency Table

Value	Count	Frequency (%)
yes	923	82.3%
no	119	10.6%
(Missing)	79	7.0%

roof_cover_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	460
10%	285
20%	119
30%	65
40%	55
Other values (6)	137

Value	Count	Frequency (%)
0%	460	41.0%
10%	285	25.4%
20%	119	10.6%
30%	65	5.8%
40%	55	4.9%
100%	36	3.2%
50%	35	3.1%
60%	27	2.4%
80%	14	1.2%
90%	13	1.2%

Length

Max length	4
Mean length	2.62176628
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

roof_sheathing_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	918
10%	61
20%	37
100%	31
30%	23
Other values (6)	51

Value	Count	Frequency (%)
0%	918	81.9%
10%	61	5.4%
20%	37	3.3%
100%	31	2.8%
30%	23	2.1%
50%	15	1.3%
40%	11	1.0%
90%	7	0.6%
70%	6	0.5%
80%	6	0.5%

Length

Max length	4
Mean length	2.208742194
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

roof_structure_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	997
10%	31
100%	26
20%	17
30%	16
Other values (6)	34

Value	Count	Frequency (%)
0%	997	88.9%
10%	31	2.8%
100%	26	2.3%
20%	17	1.5%
30%	16	1.4%
50%	10	0.9%
70%	7	0.6%
60%	7	0.6%
40%	5	0.4%
80%	3	0.3%

Length

Max length	4
Mean length	2.133809099
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

wall_cover_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	713
10%	219
20%	69
30%	37
40%	30
Other values (6)	53

Value	Count	Frequency (%)
0%	713	63.6%
10%	219	19.5%
20%	69	6.2%
30%	37	3.3%
40%	30	2.7%
100%	16	1.4%
50%	15	1.3%
60%	7	0.6%
70%	6	0.5%
80%	6	0.5%

Length

Max length	4
Mean length	2.37823372
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

wall_sheathing_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	996
10%	37
20%	19
30%	16
100%	15
Other values (6)	38

Value	Count	Frequency (%)
0%	996	88.8%
10%	37	3.3%
20%	19	1.7%
30%	16	1.4%
100%	15	1.3%
50%	13	1.2%
60%	8	0.7%
40%	7	0.6%
70%	5	0.4%
90%	3	0.3%

Length

Max length	4
Mean length	2.124888492
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

wall_structure_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	1038
100%	14
10%	13
50%	12
20%	12
Other values (6)	32

Value	Count	Frequency (%)
0%	1038	92.6%
100%	14	1.2%
10%	13	1.2%
50%	12	1.1%
20%	12	1.1%
30%	9	0.8%
40%	6	0.5%
80%	6	0.5%
60%	5	0.4%
70%	3	0.3%

Length

Max length	4
Mean length	2.086529884
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

windows_dmg
Categorical

Distinct count	11
Unique (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	1003
10%	37
100%	18
20%	18
50%	16
Other values (6)	29

Value	Count	Frequency (%)
0%	1003	89.5%
10%	37	3.3%
100%	18	1.6%
20%	18	1.6%
50%	16	1.4%
30%	9	0.8%
40%	7	0.6%
70%	5	0.4%
80%	4	0.4%
90%	2	0.2%

Length

Max length	4
Mean length	2.12132025
Min length	2

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

doors_dmg
Categorical

Distinct count	9
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

0%	1051
100%	27
50%	14
30%	8
10%	8
Other values (4)	13

Value	Count	Frequency (%)
0%	1051	93.8%
100%	27	2.4%
50%	14	1.2%
30%	8	0.7%
10%	8	0.7%
20%	7	0.6%
80%	3	0.3%
90%	2	0.2%
60%	1	0.1%

Length

Max length	4
Mean length	2.086529884
Min length	2

Value	Count	Frequency (%)
Decimal_Number	8	88.9%
Other_Punctuation	1	11.1%

Value	Count	Frequency (%)
Common	9	100.0%

Value	Count	Frequency (%)
ASCII	9	100.0%

damage_description
Categorical

HIGH CARDINALITY
MISSING

Distinct count	344
Unique (%)	77.7%
Missing	678
Missing (%)	60.5%
Memory size	8.9 KiB

No visible damage	60
Few shingles displaced	10
Personal items outside, suggests interior water damage.	8
1. Minor roof cover damage.	6
No visible damage.	6
Other values (339)	353

Value	Count	Frequency (%)
No visible damage	60	5.4%
Few shingles displaced	10	0.9%
Personal items outside, suggests interior water damage.	8	0.7%
1. Minor roof cover damage.	6	0.5%
No visible damage.	6	0.5%
See General Notes.	4	0.4%
Few shingles blown out	3	0.3%
Gutters damaged	2	0.2%
Soffit damage	2	0.2%
Interior damage due to surge	2	0.2%
Other values (334)	340	30.3%
(Missing)	678	60.5%

Length

Max length	336
Mean length	21.92685103
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	25	37.9%
Uppercase_Letter	20	30.3%
Decimal_Number	7	10.6%
Other_Punctuation	7	10.6%
Math_Symbol	2	3.0%
Control	1	1.5%
Close_Punctuation	1	1.5%
Open_Punctuation	1	1.5%
Dash_Punctuation	1	1.5%
Space_Separator	1	1.5%

Value	Count	Frequency (%)
Latin	45	68.2%
Common	21	31.8%

Value	Count	Frequency (%)
ASCII	66	100.0%

water_height_inches
Real number (ℝ_≥0)

MISSING

Distinct count	20
Unique (%)	35.1%
Missing	1064
Missing (%)	94.9%
Infinite	0
Infinite (%)	0.0%

Mean	28.70175438596491
Minimum	0.0
Maximum	120.0
Zeros	4
Zeros (%)	0.4%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18
median	24
Q3	36
95-th percentile	52
Maximum	120
Range	120
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	20.63367992
Coefficient of variation (CV)	0.7188996059
Kurtosis	9.309962079
Mean	28.70175439
Median Absolute Deviation (MAD)	10
Skewness	2.49605869
Sum	1636
Variance	425.7487469

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
22	8	0.7%
36	7	0.6%
24	7	0.6%
12	6	0.5%
30	4	0.4%
34	4	0.4%
18	4	0.4%
0	4	0.4%
29	2	0.2%
15	1	0.1%
Other values (10)	10	0.9%
(Missing)	1064	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	0.4%
12	6	0.5%
15	1	0.1%
17	1	0.1%
18	4	0.4%

Value	Count	Frequency (%)
120	1	0.1%
108	1	0.1%
60	1	0.1%
50	1	0.1%
48	1	0.1%

structure_usable
Boolean

MISSING

Distinct count	2
Unique (%)	0.2%
Missing	54
Missing (%)	4.8%
Memory size	8.9 KiB

yes	817
no	250
(Missing)	54

Frequency Table

Value	Count	Frequency (%)
yes	817	72.9%
no	250	22.3%
(Missing)	54	4.8%

qc_id
Categorical

Distinct count	20
Unique (%)	1.8%
Missing	4
Missing (%)	0.4%
Memory size	8.9 KiB

Fernando Plaz	286
Aravind Viswanathan	227
Courtney Hodges	155
Robyn Manhard	146
Andrew Bartolini	141
Other values (15)	162

Value	Count	Frequency (%)
Fernando Plaz	286	25.5%
Aravind Viswanathan	227	20.2%
Courtney Hodges	155	13.8%
Robyn Manhard	146	13.0%
Andrew Bartolini	141	12.6%
Robyn Manhard and Andrew Bartolini	82	7.3%
David Roueche	24	2.1%
Brett Davis	13	1.2%
Andrei Perim	10	0.9%
Saman Farhangdoust	8	0.7%
Other values (10)	25	2.2%

Length

Max length	47
Mean length	16.544157
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	20	58.8%
Uppercase_Letter	12	35.3%
Space_Separator	1	2.9%
Other_Punctuation	1	2.9%

Value	Count	Frequency (%)
Latin	32	94.1%
Common	2	5.9%

Value	Count	Frequency (%)
ASCII	34	100.0%

qc_code
Categorical

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

2a	1035
2b	86

Value	Count	Frequency (%)
2a	1035	92.3%
2b	86	7.7%

Length

Max length	2
Mean length	2
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	2	66.7%
Decimal_Number	1	33.3%

Value	Count	Frequency (%)
Latin	2	66.7%
Common	1	33.3%

Value	Count	Frequency (%)
ASCII	3	100.0%

qc_notes
Categorical

HIGH CARDINALITY
MISSING

Distinct count	919
Unique (%)	85.6%
Missing	48
Missing (%)	4.3%
Memory size	8.9 KiB

Location adjusted. Aerial photo added. All other available data entered.	25
Updated address and coordinates. Assigned building material, damage ratios and overall damage rating.	13
Adjusted coordinates. Assigned building material, damage ratios and overall damage rating.	12
Updated address and coordinates. Assigned building material and overall damage rating.	12
Coordinates adjusted. Aerial photo added. Year built/effective year built added.	12
Other values (914)	999

Value	Count	Frequency (%)
Location adjusted. Aerial photo added. All other available data entered.	25	2.2%
Updated address and coordinates. Assigned building material, damage ratios and overall damage rating.	13	1.2%
Adjusted coordinates. Assigned building material, damage ratios and overall damage rating.	12	1.1%
Updated address and coordinates. Assigned building material and overall damage rating.	12	1.1%
Coordinates adjusted. Aerial photo added. Year built/effective year built added.	12	1.1%
Coordinates adjusted. Editorial check. Assigned overall damage rating.	7	0.6%
Updated address and coordinates. Editorial check. Assigned overall damage rating.	7	0.6%
Adjusted coordinates. Editorial check. Assigned overall damage rating.	6	0.5%
Coordinates adjusted. Editorial changes. Assigned overall damage rating.	6	0.5%
Aerial photo added. Year built/effective year built added.	6	0.5%
Other values (909)	967	86.3%
(Missing)	48	4.3%

Length

Max length	747
Mean length	192.1570027
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	26	33.8%
Uppercase_Letter	25	32.5%
Decimal_Number	10	13.0%
Other_Punctuation	10	13.0%
Math_Symbol	1	1.3%
Dash_Punctuation	1	1.3%
Control	1	1.3%
Open_Punctuation	1	1.3%
Space_Separator	1	1.3%
Close_Punctuation	1	1.3%

Value	Count	Frequency (%)
Latin	51	66.2%
Common	26	33.8%

Value	Count	Frequency (%)
ASCII	77	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	fulcrum_id	latitude	longitude	name_of_surveyor	date_of_survey	type_of_disaster	_project	general_notes	photos	photos_caption	photos_url	overall_building_condition	building_address_sub_thoroughfare	building_address_thoroughfare	building_address_suite	building_address_locality	building_address_sub_admin_area	building_address_admin_area	building_address_postal_code	building_address_country	building_address_full	assessment_type	assessment_type_other	year_built	effective_year_built	number_of_stories	roof_shape	roof_shape_other	roof_cover	roof_cover_other	wall_cladding	wall_cladding_other	other_details	structural_framing_system	structural_framing_system_other	roof_sheathing_nail_spacing	roof_sheathing_nail_size	roof_sheathing_nail_size_other	roof_to_wall_connection	roof_to_wall_connection_other	opening_protection	opening_protection_other	garage_door	garage_door_location	garage_door_failure	other_structural_details	damage_modes	damage_modes_other	number_of_sides_used	damage_visible_in_photos	roof_cover_dmg	roof_sheathing_dmg	roof_structure_dmg	wall_cover_dmg	wall_sheathing_dmg	wall_structure_dmg	windows_dmg	doors_dmg	damage_description	water_height_inches	structure_usable	qc_id	qc_code	qc_notes
0	cf4e5e73-25fd-46d2-9055-d3a7fed1b836	26.170294	-81.698241	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	34d42212-4da1-4fbc-97d3-32541a30b36e,09273e26-a0e9-43bc-ac10-ac87c369c919,22341f93-3172-4686-9c16-0b6df3c0a2cf,8537db33-3d65-4d81-8b03-983cd25da4c0	,,,	https://web.fulcrumapp.com/photos/view?photos=34d42212-4da1-4fbc-97d3-32541a30b36e%2C09273e26-a0e9-43bc-ac10-ac87c369c919%2C22341f93-3172-4686-9c16-0b6df3c0a2cf%2C8537db33-3d65-4d81-8b03-983cd25da4c0	2	4571	32nd Ave SW	NaN	Naples	Collier	FL	34116.0	US	4571 32nd Ave SW Naples Collier FL 34116 US	Single Family Residence	NaN	1982.0	NaN	1.0	Gable	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	Shutters	NaN	NaN	NaN	NaN	NaN	Wind	NaN	NaN	NaN	10%	10%	10%	0%	0%	0%	0%	0%	Back porch overhang failed.	NaN	NaN	Robyn Manhard	2a	Added address and overall building condition. Changed name of surveyor to "Daniel Smith". Coordinates adjusted. Photos added from duplicate record. Changed damage level to Moderate. Aerial photo added. Damage ratios added.
1	4c5b4160-a159-4e2d-ab5b-633e0ab6ea10	26.170554	-81.701669	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	26278367-e6db-43a2-9cfb-b5b61ea9b4e7,89f39622-26c8-4058-a10c-44ffcbe2b0e8	,	https://web.fulcrumapp.com/photos/view?photos=26278367-e6db-43a2-9cfb-b5b61ea9b4e7%2C89f39622-26c8-4058-a10c-44ffcbe2b0e8	2	3168	Tropicana Blvd	NaN	Naples	Collier	FL	34116.0	US	3168 Tropicana Blvd Naples Collier FL 34116 US	Single Family Residence	NaN	1996.0	NaN	1.0	Gable	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	Shutters	NaN	NaN	NaN	NaN	NaN	Wind	NaN	2.0	yes	20%	0%	0%	0%	0%	0%	0%	0%	Roof cover damage to back of house evident in aerials.	NaN	NaN	Robyn Manhard	2a	Added address and overall building condition. Changed name of surveyor to "Daniel Smith". Moved coordinates from road to building footprint. Added aerial imagery and roof cover damage ratio.
2	45364fba-92df-4e4f-8f06-e3b89d6780ae	26.170624	-81.700674	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	b781a39c-0157-4bb3-b5e4-37fe658a9007,8dc4896d-9d98-499b-a310-54041369bd52	,	https://web.fulcrumapp.com/photos/view?photos=b781a39c-0157-4bb3-b5e4-37fe658a9007%2C8dc4896d-9d98-499b-a310-54041369bd52	2	4738	31st Pl SW	NaN	Naples	Collier	FL	34116.0	US	4738 31st Pl SW Naples Collier FL 34116 US	Single Family Residence	NaN	1980.0	NaN	1.0	Hip	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Wind	NaN	2.0	yes	30%	0%	0%	0%	0%	0%	0%	0%	Extensive roof cover damage to back (south slope) of roof.	NaN	NaN	Robyn Manhard	2a	Added address and overall building condition. Changed name of surveyor to "Daniel Smith". Coordinates adjusted. Aerial image added.
3	b7ffb5ec-934e-4b9a-bfea-414268a382c9	26.170672	-81.699016	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	ae9d29ca-8113-4c5c-a3e9-d1e11ca859c3,ca1079fc-f7a9-43fd-846f-1456f0c1764e	,	https://web.fulcrumapp.com/photos/view?photos=ae9d29ca-8113-4c5c-a3e9-d1e11ca859c3%2Cca1079fc-f7a9-43fd-846f-1456f0c1764e	1	4600	31st Pl SW	NaN	Naples	Collier	FL	34116.0	US	4600 31st Pl SW Naples Collier FL 34116 US	Single Family Residence	NaN	1981.0	NaN	1.0	Hip	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Wind	NaN	NaN	NaN	0%	0%	0%	10%	0%	0%	0%	0%	Minor soffit damage, treated as wall cover.	NaN	NaN	Robyn Manhard	2a	Added address and overall building condition. Changed name of surveyor to "Daniel Smith". Coordinates adjusted.
4	64303880-d6ab-4145-8538-d81f749f761d	26.174235	-81.691659	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	5d56a147-227d-42ec-8877-a8f2492171fc,ac55cc9c-9114-40ae-a40a-4635ab01a7f0	,	https://web.fulcrumapp.com/photos/view?photos=5d56a147-227d-42ec-8877-a8f2492171fc%2Cac55cc9c-9114-40ae-a40a-4635ab01a7f0	1	4214	29th Pl SW	NaN	Naples	Collier	FL	34116.0	US	4214 29th Pl SW Naples Collier FL 34116 US	Single Family Residence	NaN	2002.0	NaN	1.0	Hip	NaN	Tile (clay)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Wind	NaN	2.0	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	NaN	Robyn Manhard	2a	Changed surveyor name to Daniel Smith. Added Overall Building Condition. Adjusted coordinates. Survey date corrected. Roof cover damage added. Aerial image added.
5	6b2460c5-f17d-4200-8569-76ecdf5e67c9	26.173686	-81.689639	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	78a9493a-c969-4597-b73f-9dd98ec9694c,6c51b4d7-7368-4306-8720-0daa30d6d867	,	https://web.fulcrumapp.com/photos/view?photos=78a9493a-c969-4597-b73f-9dd98ec9694c%2C6c51b4d7-7368-4306-8720-0daa30d6d867	1	2995	41st St SW	NaN	Naples	Collier	FL	34116.0	US	2995 41st St SW Naples Collier FL 34116 US	Single Family Residence	NaN	1980.0	NaN	1.0	Hip	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	NaN	Robyn Manhard	2a	Added building address and adjusted GPS coordinates. Added building condition. Changed Surveyor name to Daniel Smith. Survey date corrected. 10% roof cover damage added based on aerials and photo.
6	659e0299-da6c-448b-8c8a-04e4ac4b842b	26.170612	-81.690661	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	086359d1-022a-4e6e-890c-986b4df55b73,366e794d-ebd1-40a9-820e-5a4114babf91	,	https://web.fulcrumapp.com/photos/view?photos=086359d1-022a-4e6e-890c-986b4df55b73%2C366e794d-ebd1-40a9-820e-5a4114babf91	1	4157	32nd Ave SW	NaN	Naples	Collier	FL	34116.0	US	4157 32nd Ave SW Naples Collier FL 34116 US	Single Family Residence	NaN	1992.0	NaN	1.0	Hip	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.0	yes	20%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	NaN	Robyn Manhard	2a	Added address and adjusted coordinates. Changed surveyor name to Daniel Smith. Added overall building condition. Survey date corrected. Up to 20% roof cover may be damaged based on aerials and photo.
7	c320ab17-f8f5-4ef5-a232-c65d1c9445d6	26.170614	-81.691139	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	b808536a-5c5b-46da-abd7-ceac20ff2d76	NaN	https://web.fulcrumapp.com/photos/view?photos=b808536a-5c5b-46da-abd7-ceac20ff2d76	1	4185	32nd Ave SW	NaN	Naples	Collier	FL	34116.0	US	4185 32nd Ave SW Naples Collier FL 34116 US	Single Family Residence	NaN	1980.0	NaN	1.0	Gable	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	Unknown	NaN	NaN	Unknown	NaN	NaN	NaN	None	NaN	NaN	NaN	NaN	NaN	Wind	NaN	1.0	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	NaN	Robyn Manhard	2a	Added building address and adjusted coordinates. Changed surveyor name to Daniel Smith. Added overall building condition. Survey date corrected. Address verified. Damage ratio added based on photo alone.
8	77814e2b-ce3b-4660-b433-c08a9a87cf8a	26.170559	-81.692123	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	e106279c-d2e8-4d45-b78b-996ad2d2debb,c4af2b35-6db2-46f7-89c0-96f5cd9e0cb9	,	https://web.fulcrumapp.com/photos/view?photos=e106279c-d2e8-4d45-b78b-996ad2d2debb%2Cc4af2b35-6db2-46f7-89c0-96f5cd9e0cb9	1	4243	32nd Ave SW	NaN	Naples	Collier	FL	34116.0	US	4243 32nd Ave SW Naples Collier FL 34116 US	Single Family Residence	NaN	1995.0	NaN	1.0	Hip	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	Unknown	NaN	NaN	Unknown	NaN	NaN	NaN	Shutters	NaN	yes	NaN	No	NaN	Wind	NaN	NaN	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	yes	Robyn Manhard	2a	Address updated and coordinates adjusted. Surveyor name changed to Daniel \nSmith. Overall building condition added. Survey date corrected. Aerial image added. Damage ratios added.
9	bd1d2906-d0e1-494a-9fa1-c5e1c72eb9fd	26.170528	-81.692866	Daniel Smith	9/12/2017	Hurricane	CMMI-1761461	NaN	f203eef1-98b7-4759-b95a-db0c2b878721,7d5d536b-d980-42e8-b211-5d9d0923983e	,	https://web.fulcrumapp.com/photos/view?photos=f203eef1-98b7-4759-b95a-db0c2b878721%2C7d5d536b-d980-42e8-b211-5d9d0923983e	1	4285	32nd Ave SW	NaN	Naples	Collier	FL	34116.0	US	4285 32nd Ave SW Naples Collier FL 34116 US	Single Family Residence	NaN	1984.0	NaN	1.0	Hip	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	Unknown	NaN	NaN	Unknown	NaN	Unknown	NaN	Plywood/OSB	NaN	yes	NaN	No	NaN	Wind	NaN	NaN	NaN	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	NaN	Robyn Manhard	2a	Added address and updated coordinates. Survey date corrected. Overall building condition added. Surveyor name changed to Daniel Smith. Roof cover damage updated. Aerial image attached.

Last rows

	fulcrum_id	latitude	longitude	name_of_surveyor	date_of_survey	type_of_disaster	_project	general_notes	photos	photos_caption	photos_url	overall_building_condition	building_address_sub_thoroughfare	building_address_thoroughfare	building_address_suite	building_address_locality	building_address_sub_admin_area	building_address_admin_area	building_address_postal_code	building_address_country	building_address_full	assessment_type	assessment_type_other	year_built	effective_year_built	number_of_stories	roof_shape	roof_shape_other	roof_cover	roof_cover_other	wall_cladding	wall_cladding_other	other_details	structural_framing_system	structural_framing_system_other	roof_sheathing_nail_spacing	roof_sheathing_nail_size	roof_sheathing_nail_size_other	roof_to_wall_connection	roof_to_wall_connection_other	opening_protection	opening_protection_other	garage_door	garage_door_location	garage_door_failure	other_structural_details	damage_modes	damage_modes_other	number_of_sides_used	damage_visible_in_photos	roof_cover_dmg	roof_sheathing_dmg	roof_structure_dmg	wall_cover_dmg	wall_sheathing_dmg	wall_structure_dmg	windows_dmg	doors_dmg	damage_description	water_height_inches	structure_usable	qc_id	qc_code	qc_notes
1111	62f3e8a8-6021-4587-a3ff-58b84578b7cc	26.157039	-81.738220	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	New unit installed in November 2017 with tag and wall anchors at ~3?? on center.	8cfe18d5-bf88-4408-80e3-ded44b195a95,292c3dbb-954c-43ba-872f-47d66cb69ea5	,	https://web.fulcrumapp.com/photos/view?photos=8cfe18d5-bf88-4408-80e3-ded44b195a95%2C292c3dbb-954c-43ba-872f-47d66cb69ea5	1	25	Blue Skys Dr	NaN	Naples	Collier	FL	34104.0	US	25 Blue Skys Dr Naples Collier FL 34104 US	Mobile Home	NaN	2017.0	2017.0	1.0	Gable	NaN	Asphalt shingles (3-tab)	NaN	Vinyl siding	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	no	NaN	NaN	NaN	NaN	NaN	2.0	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	yes	Courtney Hodges	2a	Coordinates adjusted. Aerial photo added. Year built/effective year built and roof cover dmg added.
1112	42932818-9c1a-4fb2-9365-cf16fa75420e	26.156314	-81.736208	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Lanai destroyed creating openings for rain infiltration. Front end Carport also destroyed.	28dcb588-58e5-4075-8696-207b63a6769f	NaN	https://web.fulcrumapp.com/photos/view?photos=28dcb588-58e5-4075-8696-207b63a6769f	1	163	Sand Dr	NaN	Naples	Collier	FL	34104.0	US	163 Sand Dr Naples Collier FL 34104 US	Mobile Home	NaN	1983.0	1983.0	1.0	Gable	NaN	Corrugated metal	NaN	Vinyl siding	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	Unknown	NaN	NaN	NaN	no	NaN	NaN	NaN	Wind	NaN	1.0	yes	10%	0%	0%	10%	0%	0%	0%	0%	NaN	NaN	yes	Courtney Hodges	2a	Coordinates adjusted. Year built/effective year built, roof cover type, wall cladding type, roof cover dmg, roof sheathing dmg, and roof structure dmg added.
1113	c9a80f9e-85e9-4b23-9ca9-e36bf9b91c84	26.155958	-81.736744	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Roof damage; lost lanai, carport	dbe59fe4-8cce-4c20-9828-7e3f5f0495a6	NaN	https://web.fulcrumapp.com/photos/view?photos=dbe59fe4-8cce-4c20-9828-7e3f5f0495a6	1	118	Kim Dr	NaN	Naples	Collier	FL	34104.0	US	118 Kim Dr Naples Collier FL 34104 US	Mobile Home	NaN	1978.0	1978.0	1.0	Gable	NaN	Corrugated metal	NaN	Vinyl siding	NaN	NaN	Wood-frame	NaN	NaN	Unknown	NaN	Unknown	NaN	None	NaN	no	NaN	NaN	NaN	Wind	NaN	2.0	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	yes	Courtney Hodges; David Roueche	2a	Location adjusted; address updated; overall damage changed from severe to minor due to majority of damage being experienced by appurtenant structure (carport).
1114	e48b4320-1bc5-49d3-a73e-c05d02667a9c	26.109616	-81.728765	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	November 2017 installation. Anchorage same as Blue Sky site. No attachments	1b55b013-ae35-42a3-8717-a2eee08d0b39,08c4adbc-7ff7-4617-97ed-be19e47f6808	,	https://web.fulcrumapp.com/photos/view?photos=1b55b013-ae35-42a3-8717-a2eee08d0b39%2C08c4adbc-7ff7-4617-97ed-be19e47f6808	0	31	Apple Tree Ln	NaN	Naples	Collier	FL	34112.0	US	31 Apple Tree Ln Naples Collier FL 34112 US	Mobile Home	NaN	2018.0	NaN	1.0	Gable	NaN	NaN	NaN	NaN	NaN	NaN	Wood-frame	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	NaN	David Roueche	2b	Home was installed post-hurricane. Should not be used in analysis.
1115	16ef20cf-4d8d-4ba8-84e5-1fd8ede3a9ff	26.109649	-81.728325	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	New unit - per management: window damaged only. Note carport attachment: engineered to break away	3f747db5-981d-4f10-82e3-e3477ae848e5,b1825231-19c3-4194-a2fe-c14043fc1027	,	https://web.fulcrumapp.com/photos/view?photos=3f747db5-981d-4f10-82e3-e3477ae848e5%2Cb1825231-19c3-4194-a2fe-c14043fc1027	1	25	Apple Tree Ln	NaN	Naples	Collier	FL	34112.0	US	25 Apple Tree Ln Naples Collier FL 34112 US	Mobile Home	NaN	2017.0	2017.0	1.0	Gable	NaN	Asphalt shingles (3-tab)	NaN	Vinyl siding	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.0	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	yes	Courtney Hodges	2a	Coordinates adjusted. Aerial photo added. Year built/effective year built and roof cover dmg added.
1116	4601bd28-82a7-483e-9e75-b32af1ef1a72	26.109866	-81.728480	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Carport destroyed - renter unaware of any water damage	d5bebfa2-0454-429c-8261-1cbd12d2b673,97fc0d3e-a11c-4444-aa72-d6924e9d6135	,	https://web.fulcrumapp.com/photos/view?photos=d5bebfa2-0454-429c-8261-1cbd12d2b673%2C97fc0d3e-a11c-4444-aa72-d6924e9d6135	1	26	Apple Tree Ln	NaN	Naples	Collier	FL	34112.0	US	26 Apple Tree Ln Naples Collier FL 34112 US	Mobile Home	NaN	NaN	NaN	1.0	Gable	NaN	Corrugated metal	NaN	Sheet metal	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	no	NaN	NaN	NaN	NaN	NaN	1.0	yes	10%	0%	0%	0%	0%	0%	0%	0%	NaN	NaN	yes	Courtney Hodges	2a	Coordinates adjusted. Aerial photo added. Roof cover, wall cladding, and roof cover dmg added. No year built available for specific unit. Minor damage to roof cover. Detached porch structure destroyed.
1117	5cf87ff9-6e75-45e4-b5d4-268e3ba3b7ac	25.923520	-81.644078	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Next door to cover 505 coconut ave	c2562355-dba3-4a4a-a015-d700cec49b8e	NaN	https://web.fulcrumapp.com/photos/view?photos=c2562355-dba3-4a4a-a015-d700cec49b8e	4	507	Coconut Ave	NaN	Goodland	Collier	FL	34140.0	NaN	507 Coconut Ave Goodland Collier FL 34140	Mobile Home	NaN	1972.0	NaN	1.0	Gable	NaN	Corrugated metal	NaN	Sheet metal	NaN	NaN	Wood-frame	NaN	NaN	Unknown	NaN	NaN	NaN	None	NaN	no	NaN	NaN	NaN	Wind	NaN	NaN	NaN	100%	100%	100%	100%	100%	100%	100%	100%	Possible surge damage as well.	NaN	NaN	David Roueche	2a	NaN
1118	5d3a9fd5-d5b6-4581-865d-283f570d6530	25.923993	-81.643508	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Roof Structure gone above carport.	f1587d6c-59d4-40b2-8906-bb5edd774296,7650d8ff-eee5-48b4-942e-18891aec2d57	,	https://web.fulcrumapp.com/photos/view?photos=f1587d6c-59d4-40b2-8906-bb5edd774296%2C7650d8ff-eee5-48b4-942e-18891aec2d57	4	505	Coconut Avenue	NaN	Goodland	Collier	FL	34140.0	NaN	505 Coconut Avenue Goodland Collier FL 34140	Single Family Residence	NaN	1980.0	1980.0	2.0	Complex	NaN	Asphalt shingles (3-tab)	NaN	Stucco	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	no	NaN	NaN	NaN	NaN	NaN	1.0	yes	30%	30%	30%	0%	0%	0%	0%	0%	NaN	NaN	no	Courtney Hodges	2a	Coordinates adjusted. Aerial photo added. Year built/effective year built, roof shape, roof cover, wall cladding, roof cover dmg, roof sheathing dmg, and roof structure dmg added.
1119	97d59c95-0910-48da-8b35-e45fe75bed6d	25.925105	-81.648313	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Metal roof damaged	88878432-6681-4f07-bed1-290e4dee20dc,f5c364f7-6e54-42e0-9cc6-a532546afda4	,	https://web.fulcrumapp.com/photos/view?photos=88878432-6681-4f07-bed1-290e4dee20dc%2Cf5c364f7-6e54-42e0-9cc6-a532546afda4	2	505	W Goodland Dr	NaN	Goodland	Collier	FL	34140.0	NaN	505 W Goodland Dr Goodland Collier FL 34140	Single Family Residence	NaN	1967.0	1967.0	1.0	Complex	NaN	Corrugated metal	NaN	Vinyl siding	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	no	NaN	NaN	NaN	NaN	NaN	1.0	no	10%	10%	0%	0%	0%	0%	0%	0%	NaN	NaN	yes	Courtney Hodges	2a	Coordinates adjusted. Address updated. Aerial photo added. Year built/effective year built, roof shape, roof cover, wall cladding, roof cover dmg, and roof sheathing dmg added.
1120	2f7e30a8-ccbb-4783-b96d-71798c3d8da3	26.046961	-81.661047	Glenn Overcash	12/15/2017	Hurricane	CMMI-1761461	Carport lost, gable end wall breached	1888a9c2-1fab-4558-824a-2fdb4ca21387,5d341cf5-86a7-4455-ad38-d7965e92f48f	,	https://web.fulcrumapp.com/photos/view?photos=1888a9c2-1fab-4558-824a-2fdb4ca21387%2C5d341cf5-86a7-4455-ad38-d7965e92f48f	3	211	Ocean Reef Ln	NaN	Naples	Collier	FL	34114.0	US	211 Ocean Reef Ln Naples Collier FL 34114 US	Mobile Home	NaN	1983.0	1983.0	1.0	Gable	NaN	Corrugated metal	NaN	Vinyl siding	NaN	NaN	NaN	NaN	NaN	Unknown	NaN	NaN	NaN	NaN	NaN	no	NaN	NaN	NaN	Wind	NaN	2.0	yes	20%	10%	0%	10%	10%	0%	0%	0%	NaN	NaN	no	Courtney Hodges	2a	Coordinates adjusted. Aerial photo added. Year built/effective year built, roof shape, roof cover, wall cladding, roof cover dmg, roof sheathing dmg, wall cover dmg, and wall sheathing dmg added.

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows